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 view? : Sql dba
What are the uses of merge?
How to get each name only once from an employee table?
Why plvtab is considered as the easiest way to access the pl/sql table?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What are different types of tables in sql?
How do I view a view in sql?
how do you login to mysql using unix shell? : Sql dba
How do I truncate a word?
Can we use commit inside a trigger?
Why join is faster than subquery?
Is inner join same as self join?
Can we insert data in view?
What are aggregate and scalar functions?
how to do backup entire database? : Transact sql
