CTXSYS (Oracle Text) - PLS-00201 problems invoking procedure
From: stef <stef99R_at_hotmail.com>
Date: 8 Apr 2003 15:03:37 -0700
Message-ID: <5e7a0b07.0304081403.7bce5bcd_at_posting.google.com>
Date: 8 Apr 2003 15:03:37 -0700
Message-ID: <5e7a0b07.0304081403.7bce5bcd_at_posting.google.com>
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
Received on Wed Apr 09 2003 - 00:03:37 CEST