Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> PLS-905 Invalid object schema.schema is invalid on 9i

PLS-905 Invalid object schema.schema is invalid on 9i

From: Ender Wiggin <ender_wiggin30_at_yahoo.com>
Date: Tue, 7 Jun 2005 22:01:35 -0600
Message-ID: <YrednfBWPYZj8TvfRVn-qA@comcast.com>


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 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 dieas why ?

Thanks

PS. The package is installed into my schema without errors. Received on Tue Jun 07 2005 - 23:01:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US