Re: Trigger Question with Commit

From: DA Morgan <>
Date: Sat, 09 Aug 2008 10:29:00 -0700
Message-ID: <> 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: scroll down to OWA_UTIL.WHO_CALLED_ME

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Sat Aug 09 2008 - 12:29:00 CDT

Original text of this message