Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> fixing the ' char ?
Hi,
I have for a problem with my intersolv drivers/foxpro
and I cannot pass the character ' directly to oracle, since it messes up
the parsing of the function, in my fox pro.
so before passing ' I convert it to a char 255.
Therefore i have to have the following code on the oracle side. but when I look at the data in the database it character has not been converted and appears as a "creature" character
any ideas?
steve
( scanstr IN VARCHAR2 )
RETURN VARCHAR2
IS
fixstr VARCHAR2 ( 4000 ):= '';
BEGIN --fix our passed value with the new value
fixstr := REPLACE(scanstr, CHR(255), CHR(39));
RETURN fixstr;
EXCEPTION
WHEN OTHERS THEN NULL; END; Received on Thu Dec 09 1999 - 03:12:04 CST