ASCII Character 49824
503283May 13 2010 — edited May 13 2010Hi,
one of my PLSQL function was failing for no reason, then when started debugging I got a string where the problem was happening. I tried to find the ASCII value for the string, and I got value of 49824. Just wondering what could be these characters, how this could have entered the database. What is the best practice to avoid these kind of character. Please share your thoughts.
-----------------------------------
My Debug Block:
DECLARE
position int;
string_1 varchar2(200);
BEGIN
position := 1;
string_1 := 'SOCs Asset Team';
WHILE position <= LENGTH(string_1) LOOP
dbms_output.put_line(ASCII(SUBSTR(string_1,position,1)) || ' -> ' || CHR(ASCII(SUBSTR(string_1,position,1))));
position := position + 1;
END LOOP;
END;
-----------------------------------
-----------------------------------
output:
115 -> s
32 ->
49824 ->
65 -> A
-----------------------------------
Thanks,
Sathish