Re: Contains with context option

From: thor hw <thor_at_echidna.net>
Date: Wed, 8 Apr 1998 09:12:26 -0700
Message-ID: <1998Apr8.091051.10099@vmsmail.gov.bc.ca>

Are the problems from the trying to build a PL/SQL routine, or from executing the SQL statement directly.
If you can call your SQL statement from SQL*Plus, but not from a stored procedure, then that's because you can't grant access to objects via roles for PL/SQL named blocks. You'll need to grant explicit access to those objects.

Thor HW

pch_at_cci-brest.fr wrote in message <6gfed9$abq$1_at_nnrp1.dejanews.com>...
>Hi,
>I have a problem with context option.
>the keyword contains is not recognized with an other user of CTXSYS.
>I have naturally grant rights (ctxapp,ctxuser) to the user.
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Wed Apr 08 1998 - 11:12:26 CDT