.

In this manner, can we use autonomous transaction in triggers?

Autonomous transactions: As workaround, one can use autonomous transactions. Autonomous transactions execute separate from the current transaction. Unlike regular triggers, autonomous triggers can contain COMMIT and ROLLBACK statements.

Secondly, what is an autonomous transaction? An autonomous transaction is an independent transaction that is initiated by another transaction, and executes without interfering with the parent transaction. When an autonomous transaction is called, the originating transaction gets suspended.

Likewise, people ask, what is the use of pragma autonomous transaction?

The AUTONOMOUS_TRANSACTION pragma changes the way a subprogram works within a transaction. A subprogram marked with this pragma can do SQL operations and commit or roll back those operations, without committing or rolling back the data in the main transaction.

Can we use Pragma Autonomous_transaction transaction in packages?

You cannot apply this pragma to an entire package or an entire an object type. Instead, you can apply the pragma to each packaged subprogram or object method. For readability, code the pragma at the top of the section. Once started, an autonomous transaction is fully independent.