14.4 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
autonomous_trans_pragma ::=
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