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

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>,
> > " ̱ \(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.
Received on Mon Jun 19 2000 - 00:00:00 CDT