ORA-04027: self-deadlock during automatic validation

Phil W

Member²
ORA-04027: self-deadlock during automatic validation

Help! This is driving me nuts and I am sure it is an easy fix. More often than not debugging is fine but today I keep on hitting this problem. I am sure I have had it working but when I add debugging information for a package I get this regardless it seems of the windows that are open.
What can I do to avoid this please?
 
Cause: An attempt was made to validate an invalidated object but it failed because of a self-deadlock.

Action: , e.g. compile the invalidated object separately.
Maybe you can use the "Compile Invalid Objects" tool to make sure that everything is valid?
 
Thanks for the tip but this doesn't fix it. If I remove the breakpoint I have, it works just fine. If I re apply the breakpoint I get this error.
 
I am having the same problem. The only solution I found so far is to use "step into" instead of setting a breakpoint. Any tip?

With regards, Helene
 
Back
Top