[Q]ConText Cartridge & Stored Procedures

Hi,

I could not find any helpfull docs about using Oracle 8 ConText Cartridge and Stored Prcedures.

The SQL - select * from mpi where CONTAINS(address,'USA') > 0;

   works just fine, but when I try to create a SP I get :

LINE/COL ERROR

-------- ---------------------------------------------------
5/23     PL/SQL: SQL Statement ignored
5/47     PLS-00201: identifier 'CONTAINS' must be declared

I've GRANTED all ctx roles to the user.

create or replace procedure spGetXXX (
 refCursor IN OUT cursors.cMPI, country IN varchar2) as

begin

    open refCursor for select * from mpi where CONTAINS(address,country)

> 0;

end; Received on Thu Mar 05 1998 - 00:00:00 CST