RE: uses of autonomous transactions
Date: Thu, 22 May 2008 13:44:10 -0400
There are many of good and bad uses for them, several Collaborate08 presentations had sections on them. For example you can avoid mutating table trigger errors with them, commit within triggers etc. It is a very powerful feature that can kill you if used improperly. In my Colloaborate08 presentation I showed a case where performance was killed by AT's and showed how to work around it.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Rick Ricky
Sent: Thursday, May 22, 2008 11:56 AM
Subject: uses of autonomous transactions
has anyone found a use for this other than for logging?
- doing stuff
- log what i am doing. commit it and don't want to commit do stuff
- continue doing stuff
anyone use it for anything else?Received on Thu May 22 2008 - 12:44:10 CDT