Re: Inserting '&' with OCI -- Help Please

Unfortunately we are not using SQL*PLUS. We are using the OCI libraries. You cannot run a SQL*PLUS command with that. Otherwise we can user set scan off, or set escape on and use an escape character.

In article <394DF4CF.EEC1D9B5_at_mitre.org>,   Peter Sylvester <peters_at_mitre.org> wrote:
> how about (in sqlplus):
> SET DEFINE OFF
>
> this turns off the '&' interpretation, or assigns another character.
> -Peter
>
> berj_kacherian_not_at_hotmail.com wrote:
> > =
 

> > If anybody has any ideas on this, your help would be greatly
> > appreciated!
> > =
 

> > In article <8i8gvf$7h3$1_at_nnrp1.deja.com>,
> > berj_kacherian_not_at_hotmail.com wrote:
> > > Thanks for the suggestion, but it did not work.
> > >
> > > It ended up inserting the following into the table:
> > >
> > > joe'&'jim
> > >
> > > I would like to insert joe&jim into the table.
> > >
> > > In article <o6l$IQZ1$GA.229_at_news1.sys.netsgo.com>,
> > > "=C0=CC=B1=A4=BF=EC\(leewin\)" <leewin_at_netsgo.com> wrote:
> > > > Hi berj_kacherian_not.
> > > >
> > > > please use '' '' , don't " "
> > > >
> > > > insert into emp values ('joe''&''jim');
> > > >
> > > > Good bye
> > > >
> > > > <berj_kacherian_not_at_hotmail.com> wrote in message
> > > > news:8i6gse$od5$1_at_nnrp1.deja.com...
> > > > > How can you insert an '&' while using OCI? Such as:
> > > > >
> > > > > insert into emp values ('joe&jim');
> > > > >
> > > > >
> > > > > Unlike using SQL*PLUS, you cannot set escape on or set scan
 off.
> > > > >
> > > > > Thanks in advance for any help!
> > > > >
> > > > > --
> > > > > Out the Ethernet, past the firewall, through the router, down
 the=  

> > > > > T1...nothing but Net
> > > > >
> > > > > In order to email me remove the '_not' from my email address.
> > > > >
> > > > >
> > > > > Sent via Deja.com http://www.deja.com/
> > > > > Before you buy.
> > > >
> > > >
> > >
> > > --
> > > Out the Ethernet, past the firewall, through the router, down the
> > > T1...nothing but Net
> > >
> > > In order to email me remove the '_not' from my email address.
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> > >
> > =
 

> > --
> > Out the Ethernet, past the firewall, through the router, down the
> > T1...nothing but Net
> > =
 

> > In order to email me remove the '_not' from my email address.
> > =
 

> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>

--
Out the Ethernet, past the firewall, through the router, down the
T1...nothing but Net

In order to email me remove the '_not' from my email address.


Sent via Deja.com http://www.deja.com/
Before you buy.