Re: Contains with context option

err... that should read "the SQL*Plus parser does." heh

Tom Hood
thomas_at_ifn.com

Thomas Hood wrote:
>
> 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:55:32 CDT