Re: HELP:ConText Option in PL/SQL

Did you put
  text_enable=true
into your init.ora file?

Takayuki Kitayama wrote:
>
> Hello.
>
> I'm trying to use CONTAINS function in PL/SQL.
> But it break out with some errors.
> Please tell me that reason?
> (Oracle 7.3.2, PL/SQL 2.3.2.2 on HPUX 10.20)
>
> This is simple example:
>
> declare
> key varchar2(16);
> begin
> select text_key into key
> from text_view
> where CONTAINS(text, 'wine')>0;
> end;
> /
>
> ERROR at line 6:
> ORA-06550: line 6, column 7:
> PLS-00201: identifier 'CONTAINS' must be declared
> ORA-06550: line 4, column 1:
> PL/SQL: SQL Statement ignored
>
> -----
> taka_at_osaka.dcl.co.jp
Received on Mon Jun 30 1997 - 00:00:00 CDT