Hi have an unusual issue, one that I haven't come across before and would appreciate some help in resolving it.
I have a pl/sql package, call it Package A and when I compile it successfully, other packages in a different schema become invalid, lets call these Package B, C and D. If I then re-compile any or all of packages B, C and D, then Package A becomes invalid. It is only the package body in all packages that is affected and even re-compiling only the package bodies gives the same results. So, I'm currently unable to compile Packages A, B, C and D and one of them is ALWAYS invalid!
The strange thing about this behaviour, is that it only occurs in our Test database. The Dev database is fine and I don't see this issue. No objects are being changed to cause the invalidation, I'm simply re-compiling package bodies.
Please provide some advice on how to troubleshoot this issue.
Thanks.