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@xxxxxxxxx> 
To: <ricks12345@xxxxxxxxx>; <oracle-l@xxxxxxxxxxxxx>
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

Other related posts: