Re: fixing the ' char ?

I tried this and it worked with no probs...

create table a (f varchar2(100)) ;
insert into a values ('a' || chr(255) || 'b') ;

select translate( f , chr(255), chr(39) ) from a ;

Or:

select replace( f , chr(255), chr(39) ) from a ; (your code)

Daniel Reis

Steve A <spectre_at_hkstar.com> wrote in message news: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
>
> -- Enter the parameters for the procedure in
>
> -- the brackets above. If this procedure has
>
> -- no parameters then delete the line
>
>
>
> -- ***************************************************
>
> -- *
>
> -- * Author steve
>
> -- * Creation Date 23/11/99
>
> -- * Comments replace value 255 with '
>
> -- *
>
> -- ***************************************************
>
>
>
> IS
>
> -- Enter all variables cursors and constants following
>
> -- this line
>
> fixstr VARCHAR2 ( 4000 ):= '';
>
> BEGIN
>
> --fix our passed value with the new value
>
> fixstr := REPLACE(scanstr, CHR(255), CHR(39));
>
>
>
> RETURN fixstr;
>
> EXCEPTION
>
> -- Enter the code to handle exception conditions
>
> -- following this line
>
> WHEN OTHERS
>
> THEN
>
> NULL;
>
> END;
>
>
Received on Thu Dec 09 1999 - 14:23:40 CST