Hi

We use ATs for pretty much all the Error/Warning/Info/Debug stuff. =
Since you
don't want to interfere with the calling transaction and leave =
potential
commits/rollbacks to the calling context, we use ATs for that.
It also gives you a good seperation between different developer's =
concerns:
They can both work on their thing without=20
having to care too much about corrupting their peer's transactions.

Stefan


-----Urspr=FCngliche Nachricht-----
Von: Ryan [mailto:ryan.gaffuri@(protected)]
Gesendet: Montag, 16. Februar 2004 20:21
An: oracle-l@(protected)
Betreff: What do you use autonomous transactions for?=20


The only thing I have used them for is logging dbms_jobs to tables. I =
do not
want the transaction to commit, but I want to track my progress.=20
What have you used them for? Anything interesting?=20
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


=20
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------