Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 905 Invalid object schema.schema is invalid on 9i
Hi,
I have recently installed Tora and I tried to debug a PL/SQL package I have
installed on my schema. During debugging, Tora gets PLS-905 error.
Suspicious, I
have run the same query through sqlplus. I got the same error.
begin
schema.package.procedure(....) ;
end ;
The above works when the package is installed in another schema or if I call without qualifying with my own schema name. Is that a bug in the Oracle 9.2.0.6 database ? It seems something is automatically appending my schema name even though it is qualified. Any ideas why ? Authentication is external.
Thanks
PS. The package is installed into my schema without errors. Received on Tue Jun 07 2005 - 22:54:02 CDT