Answer Posted / p.rajasekar
Autonomous transactions are started by a parent, or main,
transaction but operate
independently of the parent for transaction control. If a
commit or rollback is used
in the autonomous or main transaction, or if a failure
occurs for any reason, it does
not impact the other transaction.
Our favorite use of this feature is for logging application
events. If the need is to
log activity, regardless of the outcome, but the logging
success or failure should not
impact the application, autonomous transactions are the
perfect solution.
To create an autonomous transaction, use a pragma called
AUTONOMOUS_TRANSACTION. The pragma is placed in the
declaration section of the block.
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
What does count (*) do in sql?
How do you concatenate in sql?
Why is a trigger used?
Is sql a backend?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
What is meant by user defined function?
what does myisamchk do? : Sql dba
What is sql clause?
Explain what is a field in a database and record in a database?
What is a sql trace file?
How to write a query to show the details of a student from students table whose
explain normalization concept? : Sql dba
what is the difference between truncate and delete statement? : Transact sql
What are stored procedures in mysql?
what is clause? : Sql dba
