Trigger Question with Commit
From: <artmerar_at_yahoo.com>
Date: Fri, 8 Aug 2008 14:40:45 -0700 (PDT)
Message-ID: <5cace5b2-389f-4630-aa48-e712de04839f@x35g2000hsb.googlegroups.com>
Date: Fri, 8 Aug 2008 14:40:45 -0700 (PDT)
Message-ID: <5cace5b2-389f-4630-aa48-e712de04839f@x35g2000hsb.googlegroups.com>
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? Received on Fri Aug 08 2008 - 16:40:45 CDT