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

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>,
> "À̱¤¿ì\(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.