RE: What do you use autonomous transactions for?
- From: Lord David <DLord@xxxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 17 Feb 2004 08:09:57 -0000
We use them a lot in procedures that do ddl to isolate them from the main
transaction.
--
David Lord
> -----Original Message-----
> From: Ryan [mailto:ryan.gaffuri@xxxxxxx]
> Sent: 16 February 2004 19:21
> To: oracle-l@xxxxxxxxxxxxx
> Subject: What do you use autonomous transactions for?
>
>
> 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.
> What have you used them for? Anything interesting?
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
> This email and its attachments are confidential under
> applicable law and are intended for use of the sender's
> addressee only, unless the sender expressly agrees otherwise,
> or unless a separate written agreement exists between Iron
> Mountain and a recipient company governing communications
> between the parties and any data that may be so transmitted.
> Transmission of email over the Internet is not a secure
> communications medium. If you are requesting or have
> requested the transmittal of personal data, as defined in
> applicable privacy laws, by means of email or in an
> attachment to email, you may wish to select a more secure
> alternate means of transmittal that better supports your
> obligations to protect such personal data.
>
> If the recipient of this message is not the recipient named
> above, and/or you have received this email in error, you must
> take no action based on the information in this email. You
> are hereby notified that any dissemination, misuse or copying
> or disclosure of this communication by a recipient who has
> received this message in error is strictly prohibited. If
> this message is received in error, please return this email
> to the sender and immediately highlight any error in
> transmittal. Thank you.
>
*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
This e-mail and its attachments are intended for the
author's addressee only and may be confidential.
If they have come to you in error you must take no
action based on them, nor must you copy or show
them to anyone; please reply to this e-mail and
highlight the error.
Please note that this e-mail has been created in the
knowledge that Internet e-mail is not a 100% secure
communications medium. We advise that you
understand and observe this lack of security when
e-mailing us. Steps have been taken to ensure this
e-mail and attachments are free from any virus, but
advise the recipient to ensure they are actually virus
free.
The views, opinions and judgments expressed in this
message are solely those of the author. The message
contents have not been reviewed or approved by Iron
Mountain.
*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
----------------------------------------------------------------
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
-----------------------------------------------------------------
Other related posts:
