[q] ConText Option Problem

Hi there!!

I am testing Oracle ConText option 1.0
on my workstation(Solaris2.5).

At first, I could run a select clause with 'contains' function successfully.

             
           SQL>  select * from aaa where contains(aaa, 'ttt')>0 ;

And I tried to create stored procedure using a cursor ; but I countered a compile error.

          cursor kkk is
               select * from aaa where contains(aaa, 'ttt') > 0 ;

The error message is written below.

22/9     PLS-00320: the declaration of the type of this expression is
         incomplete or malformed

32/19 PLS-00201: identifier 'CONTAINS' must be declared

Please let me know what is the problem and tell me the solution.
thank you. Received on Thu Mar 27 1997 - 00:00:00 CET