AUTONOMOUS_TRANSACTION Pragma

The AUTONOMOUS_TRANSACTION pragma marks a routine as autonomous; that is, independent of the main transaction.

In this context, a routine is one of these:

• Schema-level (not nested) anonymous PL/SQL block

• Standalone, package, or nested subprogram

• Method of an ADT

• Noncompound trigger

Topics

• Syntax

• Examples

• Related Topics

Syntax

autonomous_trans_pragma ::=

Description of the illustration autonomous_trans_pragma.eps

Examples

• Example 7-43, "Declaring Autonomous Function in Package"

• Example 7-44, "Declaring Autonomous Standalone Procedure"

• Example 7-45, "Declaring Autonomous PL/SQL Block"

• Example 7-46, "Autonomous Trigger Logs INSERT Statements"

• Example 7-47, "Autonomous Trigger Uses Native Dynamic SQL for DDL"

• Example 7-48, "Invoking Autonomous Function"

Related Topics

• Pragmas

• Autonomous Transactions