dbTalk Databases Forums  

905 Invalid object schema.schema is invalid on 9i

comp.database.oracle.server comp.database.oracle.server


Discuss 905 Invalid object schema.schema is invalid on 9i in the comp.database.oracle.server forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ender Wiggin
 
Posts: n/a

Default 905 Invalid object schema.schema is invalid on 9i - 06-06-2005 , 11:59 PM






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.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.