Unable to run PATINDEX, CHARINDEX functions

From: Vlad <vtsyrlin_at_bigfoot.com>
Date: 29 May 2002 16:43:59 -0700
Message-ID: <bc7620c4.0205291543.476abe62@posting.google.com>

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 Received on Wed May 29 2002 - 18:43:59 CDT