Updated on 2025-07-15 GMT+08:00

Autonomous Transaction

An autonomous transaction is an independent transaction that is started during the execution of a main transaction. Committing and rolling back an autonomous transaction does not affect the data that has been committed by the main transaction. In addition, an autonomous transaction is not affected by the main transaction.

Autonomous transactions are defined in stored procedures, functions, and anonymous blocks, and are declared using the PRAGMA AUTONOMOUS_TRANSACTION keyword.