Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: OCI: How can I insert a string including an amphersand (&) from OCI??
Ole Hansen <oha_at_city.dk> wrote in message news:<3DA7F142.7060909_at_city.dk>...
> Hi,
>
> I have troble escaping an amphersand (&) from within OCI.
> Neither single quote (') or backslash (\) seems to work.
>
> The statement fails if I try to execute it from OCI if the string
> includes an amphersand but I dont know how to escape an amphersand (&).
>
> I really need to store the amphersand with the string.
>
> Any ideas?
>
> Thanks in advance!
> Ole Hansen
maybe you could use the char() function. it is not nice, but could work Received on Sat Oct 12 2002 - 15:46:36 CDT