Re: Trigger Question with Commit

On Fri, 8 Aug 2008 14:40:45 -0700 (PDT), 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?

A transaction is a series of dml statements which *logically* belong together.
Surely you can use an AUTONOMOUNS_TRANSACTION if you are not interested in database consistency.
However, committing in a procedure is always a bad, bad idea, and has always been discouraged by Oracle.
However, if your ambition is to set up a disaster application, no one will stop you.

-- 
Sybrand Bakker
Senior Oracle DBA