-
Oracle 9i : Compiling 1 package ruins all dependencies!!
Hi All,
I have been having a nightmare with an ORA-06508 (see http://www.dbasupport.com/forums/sho...threadid=31684)
I have managed to find something which replicates the error on tap now. What is happening is that when I compile a custom package on the fly, all its dependencies get broken.
When I say broken I mean select object_name, status from user_objects where status='INVALID' yields results.
I did the same query for dba_objects and find 1,200+ INVALIDs. This cannot be right.
I successfully ran catproc.sql last night..would this have caused problems?
I always used to compile packages on the fly in Oracle 8 but it never started chucking ORA-06508s.
Enlightenment required and appreciated!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|