|
|
|
Autonomous Transactions : Oracle
|
Autonomous transactions allow you to leave the context of the calling transaction, perform an independant transaction, and return to the calling transaction without affecting it\'s state. The autonomous transaction has no link to the calling transaction, so only commited data can be shared by both transactions.
created by tom on 2008-05-05 21:55:28
|
|
|
|
Oracle autonomous transaction
An autonomous transaction is an independent transaction that is initiated by another transaction (the parent transaction). An autonomous transaction can modify data and commit or rollback independent of the state of the parent transaction.
http://www.oradev.com/autonomous_transaction.jsp
created by syam1224 on 2008-05-05 21:58:12
|
|
AUTONOMOUS_TRANSACTION Pragma : PL/SQL User's Guide and Reference
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.
http://download-west.oracle.com/docs/cd/A97630_01/
created by syam1224 on 2008-05-05 21:59:31
|
|
Autonomous Transactions from Oracle-Base
The following types of PL/SQL blocks can be defined as autonomous transactions:
* Stored procedures and functions.
* Local procedures and functions defined in a PL/SQL declaration block.
* Packaged procedures and functions.
* Type methods.
* Top-level anonymous blocks.
http://www.oracle-base.com/articles/misc/Autonomou
created by syam1224 on 2008-05-05 21:56:51
|
|
|
