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

Home -> Community -> Usenet -> c.d.o.server -> Re: Unable to run PATINDEX, CHARINDEX functions

Re: Unable to run PATINDEX, CHARINDEX functions

From: Vlad <vtsyrlin_at_bigfoot.com>
Date: 13 Jun 2002 05:23:23 -0700
Message-ID: <bc7620c4.0206130423.1cf79760@posting.google.com>


Thanks Daniel, I used those functions with SQL server and kind of assumed that they should be available with Oracle also. cheers
Vlad

Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message news:<3CFFEC91.B74CFC46_at_exesolutions.com>...
> Vlad wrote:
>
> > Hi all,
> >
> > Trying to run PATINDEX, CHARINDEX dynamically within sql but can't
> > seems to get them working. I get the error "invalid column name" and I
> > double checked to make sure no spelling mistakes or any other errors.
> > Simple sql I am trying is:
> >
> > SELECT PATINDEX("%ball%",prpub) FROM product WHERE prnbr like '%124%'
> > ;
> >
> > The sql parser "thinks" that PATINDEX is a column and hence the
> > error.
> > I am running this on Oracle 8.1.7.0
> >
> > Note I can run other string functions such as replace, instr without
> > any probs.
> > Could it be that patindex and charindex need to be installed/added
> > separately, or what is that am I doing wrong.
> > Much appreciate any help
> >
> > Vlad
>
> Just curious ... where did you see that patindex and charindex are in
> 8.1.7?
>
> Daniel Morgan
Received on Thu Jun 13 2002 - 07:23:23 CDT

Original text of this message

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