Re: Contains with context option

Actually it's because Oracle's Pro*<whatever> parser does not recognise the ConText tokens like "contains". The PL/SQL parser does however.

Tom Hood
thomas_at_ifn.com

thor hw wrote:
>
> 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 - 14:02:13 CDT