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_transaction_pragma ::=

Description of the illustration auto_trans_pragma.gif

Examples

• Example 6-44, "Declaring Autonomous Function in Package"

• Example 6-45, "Declaring Autonomous Standalone Procedure"

• Example 6-46, "Declaring Autonomous PL/SQL Block"

• Example 6-47, "Autonomous Trigger Logs INSERT Statements"

• Example 6-48, "Autonomous Trigger Uses Native Dynamic SQL for DDL"

• Example 6-49, "Invoking Autonomous Function"

Related Topics

In this chapter:

• "EXCEPTION_INIT Pragma"

• "INLINE Pragma"

• "RESTRICT_REFERENCES Pragma"

• "SERIALLY_REUSABLE Pragma"

In other chapters:

• "Autonomous Transactions"