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@xxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> 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@xxxxxxxxxxx > > > 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@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------