context contains in procedure

I have a context server and text search application which works wonderfully, but now I want to create some procedures to text search.

For a simple example, if I were to use a query such as:

    select * from mytable
    where contains(text_col, 'me') > 0;

everything works fine. However, stick that same query inside a procedure and it results in error:

    PLS-00201: identifier 'CONTAINS' must be declared.

I've scanned the newsgroups and everyones answer seems to be to grant permissions associated with the ctxuser role directly to the procedure owner. I've done this and more.

Is there anyone who knows THE answer to this scenario?? I've got permissions coming out of the procedure owners ears!!

Much thanks for any direction on this.

Steve Received on Sun Nov 08 1998 - 12:36:54 CST