what is "PRAGMA AUTONOMOUS_TRANSACTION" mean
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: what is "PRAGMA AUTONOMOUS_TRANSACTION" mean

  1. #1
    Join Date
    Sep 2002
    Posts
    411

    what is "PRAGMA AUTONOMOUS_TRANSACTION" mean

    I read this on technet but I got confused and don't know what they mean. could someone give me a clear explanation????

    thanks

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    http://tahiti.oracle.com

    The AUTONOMOUS_TRANSACTION pragma instructs the PL/SQL compiler to mark a routine as autonomous (independent). An autonomous transaction is an independent transaction started by another transaction, the main transaction. Autonomous transactions let you suspend the main transaction, do SQL operations, commit or roll back those operations, then resume the main transaction. For more information, see "Doing Independent Units of Work with Autonomous Transactions".

    ??

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    RTFM
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width