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

[Quoted] In article <3DA7F0F8.2060801_at_city.dk>, Ole says...
>
>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.
>

[Quoted] you'll have to show us an example since & is meaningless to OCI

It only means something in sqlplus (and you use "set define off" to make it mean nothing in there).

& in OCI is just like "X" or "A" -- just another character.

>Any ideas?
>
>Thanks in advance!
>Ole Hansen
>

--
Thomas Kyte (tkyte_at_oracle.com)             http://asktom.oracle.com/ 
[Quoted] Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp