Re: 905 Invalid object schema.schema is invalid on 9i

Ender Wiggin wrote:
> 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.

No DDL
No DML
Incomplete error text

What do you expect anyone to make of: schema.package.procedure(....)? That parameters are irrelevant?

No help possible unless you post a reasonable amount of information.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)