How to find out special characters? [message #84376] |
Mon, 08 March 2004 20:19 |
Shyamal
Messages: 3 Registered: October 2002
|
Junior Member |
|
|
In a datablock, I've one charcter field(e.g. Name). I want to raise error message if there is/are any special charcters present other than 0-9,A-Z and a-z. How can I do this? Is there any built-in function to do this?
|
|
|
Re: How to find out special characters? [message #84378 is a reply to message #84376] |
Mon, 08 March 2004 21:02 |
sameer_am2002
Messages: 129 Registered: September 2002
|
Senior Member |
|
|
declare
ln_len number ;
lv_char varchar2(1) ;
begin
ln_len := length(:text_item4) ;
for x in 1..ln_len loop
lv_char := substr(:text_item4 , x , 1) ;
if upper(lv_char) not between 'A' and 'Z' and lv_char not between '0' and '9' then
message('Invalid Character') ;
end if ;
end loop ;
end ;
|
|
|