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

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

-- 
Regards, Frank van Bortel