Trigger Question with Commit
Date: Fri, 8 Aug 2008 14:40:45 -0700 (PDT)
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