Path: news.easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!logbridge.uoregon.edu!news-west.eli.net!not-for-mail
Message-ID: <3CFFEC91.B74CFC46@exesolutions.com>
From: Daniel Morgan <dmorgan@exesolutions.com>
X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: Unable to run PATINDEX, CHARINDEX  functions
References: <bc7620c4.0205291543.476abe62@posting.google.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 29
Date: Thu, 06 Jun 2002 23:13:31 GMT
NNTP-Posting-Host: 156.74.250.7
X-Complaints-To: yvonne.tracy@ci.seattle.wa.us
X-Trace: news-west.eli.net 1023405211 156.74.250.7 (Thu, 06 Jun 2002 17:13:31 MDT)
NNTP-Posting-Date: Thu, 06 Jun 2002 17:13:31 MDT
Organization: City of Seattle NewsReader Service
Xref: easynews comp.databases.oracle.server:149806
X-Received-Date: Thu, 06 Jun 2002 16:10:55 MST (news.easynews.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