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>
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.orgReceived on Sat Aug 09 2008 - 12:29:00 CDT