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

Home -> Community -> Usenet -> c.d.o.server -> Re: OCI: How can I insert a string including an amphersand (&) from OCI??

Re: OCI: How can I insert a string including an amphersand (&) from OCI??

From: Victor Kaminsky <victorkaminsky_at_yahoo.de>
Date: 12 Oct 2002 13:46:36 -0700
Message-ID: <90a73003.0210121246.57f6feb1@posting.google.com>


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

Original text of this message

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