Re: CTXSYS (Oracle Text) - PLS-00201 problems invoking procedure

Frank <fvanbortel_at_netscape.net> wrote in message news:<3E947232.4010102_at_netscape.net>...
> stef wrote:
> > begin
> > ctx_dll.sync_index('IDX_FULLTEXT','2M');
> > end;
> >
> >
> > PLS-00201: Identifier 'CTXSYS.CTX_DLL' must be declared...
> >
> > I am trying to execute a procedure residing under schema CTXSYS from
> > under schema X. I granted a role (CTXAPP) to user X that grants the
> > execute privilege for multiple objects under CTXSYS.
> > In an Oracle manual I found that this behaviour (error PLS-00201) is
> > normal and that the grant execute should be given explicitly to user
> > X. So, I did do this. Besides that I gave X DBA rights (EXECUTE
> > ANY). But still, I receive the same error.
> >
> > Any ideas ?
> >
> > tx
>
> Your executing user does not know ctx_dll. Try ctxapp.ctx_dll, or
> create a synonym (either private, or public) for ctxapp.ctx_dll

Dank u Frank,

Using a public synonym works. I still ask myself if it is not possible to call the procedure directly. I tried "ctxsys.ctx_dll.sync_index(...);" but it resulted in PLS-00201. I suppose the syntax is wrong ? Can anyone provide the correct syntax or tell me where to look for it ? Received on Fri Apr 11 2003 - 13:00:51 CEST