AUTONOMOUS_TRANSACTION Pragma

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 6-43, "Declaring Autonomous Function in Package"

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

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

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

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

• Example 6-48, "Invoking Autonomous Function"

Related Topics

• Pragmas

• Autonomous Transactions