Re: uses of autonomous transactions
Date: Sat, 24 May 2008 10:26:53 +0100
> For example you can avoid mutating table
> trigger errors with them,
With a high probability that most people don't realised what the side-effects of read-consistency are going to do, and end up with incorrect data.
Author: Cost Based Oracle: Fundamentals
The Co-operative Oracle Users' FAQ
- Original Message ----- From: "Ken Naim" <kennaim_at_gmail.com> To: <ricks12345_at_gmail.com>; <oracle-l_at_freelists.org> Sent: Thursday, May 22, 2008 6:44 PM Subject: RE: uses of autonomous transactions
> 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.