Re: OCI: How can I insert a string including an amphersand (&) from OCI??
From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 12 Oct 2002 09:38:18 -0700
Message-ID: <92eeeff0.0210120838.1f8957e_at_posting.google.com>
Date: 12 Oct 2002 09:38:18 -0700
Message-ID: <92eeeff0.0210120838.1f8957e_at_posting.google.com>
Ole Hansen <oha_at_city.dk> wrote in message news:<3DA7F1A6.8070000_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
Use ASCII value of & i.e. CHR(38). To store abcd&efgh, Insert into foo values ('abcd' || CHR(38) || 'efgh');
/Rauf Sarwar Received on Sat Oct 12 2002 - 18:38:18 CEST