Oracle Autonomy-Autonomous transaction

One use rule: before begin, affirm: PRAGMA autonomous_transaction;

Two-use understanding:Autonomous Transaction is an independent transaction, which is understood autonomous transaction

The key, though called by the main transaction. Let's use an example to deepen your understanding. creates a test table, inserts two records into it, does not commit, declares an autonomous transaction, continues to insert records into the table, and commits the inserted record on the autonomous transaction. We can tell from the outputthat the control of maintransaction and autonomous transaction is independent. Autonomous transaction commits will not be submitted to main transaction, and the rollback of main transaction will not affect autonomous transaction.

Oracle Autonomy-Autonomous transaction