Re: ora-04091, updating same table in trigger
Date: Wed, 22 Apr 2009 06:38:10 -0600
I've had to deal with that issue as well.
In my database, my workaround was taking some of the logic out of the trigger and creating procedures that get called from the trigger.
In the trigger itself, I have to use the "PRAGMA AUTONOMOUS_TRANSACTION;" declaration, and use several 'COMMIT' statements inside the trigger, like before the calls to the procedures, at the end of the trigger, etc. It took a bit of experimentation, but I finally got it all figured out and working correctly.
This is on 22.214.171.124 on Windows Server 2003, so I'm not sure if this will work the same on other/previous versions or O/S's.
Hope this helps.
- Bill Ferguson -- http://www.freelists.org/webpage/oracle-l