Interested to Buy Any Domain ? << Click Here >> for more details...
Is it possible to use Transaction control Statements such a
ROLLBACK or COMMIT in Database Trigger ? Why ?
- 5 Answers
- 16886 Views
- I also Faced
- E-Mail Answers
Answer Posted / aravinda
We can't write COMMIT or ROLLBACK in triggers, because the
triggering event may commit or may not. trigger commit or
rollback is based on triggering event.
even we can't call a subprogram in a trigger which is having
commit or rollback.
but we can achieve through pragma autonomous transaction.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Can we use two order by clause in query?
Can I call a procedure inside a function?
How to call shell script from pl sql procedure?
Is it possible for a table to have more than one foreign key?
Can you sum a count in sql?
Is sqlite free?
What is sql lookup?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
What is the least restrictive isolation level? : Transact sql
What is the use of index in sql?
How do I find duplicates in a single column in sql?
What are the types of subqueries?
describe transaction-safe table types in mysql : sql dba
what is a constraint? Tell me about its various levels. : Sql dba
Are there any features that are decommissioned in 11g that are not present in 11g?
