Re: ConText CONTAINS in PL/SQL

From: Richard Murphy <rmurphy_at_lbpc.com>
Date: Fri, 15 Jan 1999 09:39:27 -0600
Message-ID: <369F612F.F23746D8@lbpc.com>

That does not work from within a PL/SQL block. For some reason PL/SQL does not recognize the CONTAINS function. It works fine using SQL or embedded SQL (ProC), but not from within a block - i get a CONTAINS not declared error.

Thanks though, R.

"Rüdiger J. Schulz" wrote:

> try the following sql-statement for a one-step-query:
>
> select test1, test2 from tablename where CONTAINS(test1,
> 'searchvalue') > 0;
>
> (here is test1 the column on which the context-policy runs)
>
> Richard Murphy schrieb:
>
> > Anyone know how to access the ConText CONTAINS function from within a
> > PL/SQL block? Most likely the only way is a two step query, but would
> > prefer a one step query.
> >
> > Thanks, R.
>
> --
> b e r l i n . d e - d e r o n l i n e d i e n s t d e r s t
> a d t
> ___________________________________________________________
> Primus-Online Berlin-Brandenburg GmbH & Co. KG
> debis Haus am Potsdamer Platz
> 10875 Berlin
>
> Rüdiger J. Schulz
> Technik
>
> tel: +49 (30) 2554-1497
> fax: +49 (30) 2554-3725
> email: r.schulz_at_berlin.de
> homepage: http://www.berlin.de
Received on Fri Jan 15 1999 - 09:39:27 CST