Trigger Question with Commit

From: <>
Date: Fri, 8 Aug 2008 14:40:45 -0700 (PDT)
Message-ID: <>


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? Received on Fri Aug 08 2008 - 16:40:45 CDT

Original text of this message