Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> fixing the ' char ?

fixing the ' char ?

From: Steve A <spectre_at_hkstar.com>
Date: Thu, 9 Dec 1999 17:12:04 +0800
Message-ID: <1e2k26x.q88lqb1hmqc6uN@[192.168.2.74]>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US