Instead of trigger hangs while compiling when a DB Link to "SELF" exists.
While trying to compile the trigger below with a DB Link to itself the compilation seems to hang forever
this requires us to kill the session as it never times out.
When dropping the link and commenting out the DB link reference there is no problem compiling the trigger.
Another workaround we have found is to create the DB Link pointing to another schema, compiling the trigger and then changing the DB Link to point to itself.
This seems to work without a problem.
Any ideas out there as to what is causing this strange behaviour?
DB used Oracle 10.2.0.1.0
DB Link Script
When dropping the link and commenting out the DB link reference there is no problem compiling the trigger.
Another workaround we have found is to create the DB Link pointing to another schema, compiling the trigger and then changing the DB Link to point to itself.
This seems to work without a problem.
Any ideas out there as to what is causing this strange behaviour?
DB used Oracle 10.2.0.1.0
DB Link Script
0