Re: uses of autonomous transactions
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- 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.
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
