Re: Trigger Question with Commit

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 09 Aug 2008 10:29:00 -0700
Message-ID: <1218302931.693566@bubbleator.drizzle.com>


artmerar_at_yahoo.com wrote:
> Hi,
>
> 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.

Here's how:
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.org
Received on Sat Aug 09 2008 - 12:29:00 CDT

Original text of this message