Re: Trigger Question with Commit
Date: Sat, 09 Aug 2008 10:29:00 -0700
> I know that you cannot commit inside a trigger. But, the trigger I
> have calls a procedure. That procedure inserts into another table and
> issues a commit.
> Problem is that the procedure is not only called from the trigger, but
> other procedures. So, sometimes a commit is needed.
> Can I use AUTONOMOUS_TRANSACTION for the call which is initiated from
> the trigger?
Fix the procedure so that it does not commit when called by a trigger.
http://www.psoug.org/reference/owa_util.html scroll down to OWA_UTIL.WHO_CALLED_ME
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Sat Aug 09 2008 - 12:29:00 CDT