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!