Re: uses of autonomous transactions

> 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.

Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

• 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.

--
http://www.freelists.org/webpage/oracle-l