Re: CTXSYS (Oracle Text) - PLS-00201 problems invoking procedure
Date: Mon, 14 Apr 2003 20:28:30 +0200
Message-ID: <3E9AFDCE.8030102_at_netscape.net>
stef wrote:
> stef99R_at_hotmail.com (stef) wrote in message news:<5e7a0b07.0304110052.59af84ef_at_posting.google.com>...
>
>>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 ?
> > > > As it seems during database installation Oracle creates a whole bunch > of synonyms. Those for Oracle Text all point to package body objects. > I suppose it would work if they would point to the package objects > (as it works after I created the synonym for the package object). Is > this intended or is this a mistake from Oracle ?
?!?
create package xxxx
...
end;
/
create package body xxxx
It's still xxxx, spec or body, no difference. Can you explain? What synonym did you have, pointing where, and what is it pointing to now (in a working situation)?
-- Regards, Frank van BortelReceived on Mon Apr 14 2003 - 20:28:30 CEST