Interested to Buy Any Domain ? << Click Here >> for more details...
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 is pl sql block in dbms?
What is a relationship and what are they?
what is a database lock ? : Sql dba
how can we destroy the session, how can we unset the variable of a session? : Sql dba
What is record in pl sql?
What is the syntax and use of the coalesce function?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
How many types of tables are there?
What is pragma in pl sql?
Define concurrency control. : Transact sql
How to write pl sql program in mysql command prompt?
What are the types of queries in sql?
Explain select statements in sql?
Is left join and outer join same?
Can a commit statement be executed as part of a trigger?
