| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: What do you use autonomous transactions for?
To debug,
for exapmle you have a procedure, that procedure failed and must rollback,
but you want
to save the error code;
----- Original Message -----
From: "Michael Milligan" <Michael.Milligan_at_ingenix.com>
To: <oracle-l_at_freelists.org>
Sent: Monday, March 15, 2004 12:48 PM
Subject: RE: What do you use autonomous transactions for?
> You use them to make a DML change in a stored program that is called from
a
> trigger, when the change is to the table the trigger is attached to. Also
> used any time you need a separate memory space for a transaction.
>
> Thanks,
>
> Mike
>
> Michael Milligan
> Oracle DBA
> Ingenix, Inc.
> 2525 Lake Park Blvd.
> Salt Lake City, Utah 84120
> wrk 801-982-3081
> mbl 801-628-6058
> michael.milligan_at_ingenix.com
>
>
> This e-mail, including attachments, may include confidential and/or
> proprietary information, and may be used only by the person or entity to
> which it is addressed. If the reader of this e-mail is not the intended
> recipient or his or her authorized agent, the reader is hereby notified
that
> any dissemination, distribution or copying of this e-mail is prohibited.
If
> you have received this e-mail in error, please notify the sender by
replying
> to this message and delete this e-mail immediately.
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> 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
> -----------------------------------------------------------------
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue Mar 16 2004 - 09:08:48 CST
 |
 |