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: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 06 Jun 2002 23:13:31 GMT
Message-ID: <3CFFEC91.B74CFC46@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 06 2002 - 18:13:31 CDT

Original text of this message

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