[q] ConText Option Problem

From: nhcho <nhcho_at_ray.co.kr>
Date: 1997/03/28
Message-ID: <01bc3b13$f2e76680$300478d2_at_phoenix.ray.co.kr>#1/1

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.

---

  Name : Nam-hee Cho
  E-mail : nhcho_at_sky.ray.co.kr
  Tel.(O): +82-2-593-1312
  Home Page : http://www.ray.co.kr:8050/

---

Received on Fri Mar 28 1997 - 00:00:00 CET