Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Invalid characters in a string

Re: Invalid characters in a string

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/02/16
Message-ID: <38AA77E7.41D@yahoo.com>#1/1

Boogie wrote:
>
> Hi Connor,
>
> Would "escaping" the character help, - cant test it cause tooooo lazy to
> walk down stairs to turn on the Solaris machine !
>
> Boogie
> Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message
> news:38A40083.3052_at_yahoo.com...
> > Patrick Joyal wrote:
> > >
> > > What are the invalid characters (in string values) that I should watch
 for
> > > where I'm constructing SQL String?
> > >
> > > I know there's ' that I can replace with ''
> > > but I'm having problem with ;
> > >
> > > thanks
> > >
> > > Patrick
> >
> > ';' is not a problem character in the db, its just that its a problem
> > character in SQL Plus...
> >
> > In SQL Plus, do
> >
> > SQL> show all
> >
> > and you can see what characters are going to be important
> >
> > HTH
> > --
> > ===========================================
> > Connor McDonald
> > There are 3,434,679 oracle websites around the world.
> > Now there is one more... http://www.oracledba.co.uk

G'day Pete,

I haven't tried it - but if I had to guess, I think SQL Plus may intervene before the SQL gets to the database engine - somehow I doubt SQL Plus is smart enough to see the word "escape" and work it what to do...

Cheers
C

-- 
===========================================
Connor McDonald
There are 3,434,679 oracle websites around the world.
Now there is one more... http://www.oracledba.co.uk
Received on Wed Feb 16 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US