Is it possible to use Transaction control Statements such a
ROLLBACK or COMMIT in Database Trigger ? Why ?
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
what is clause? : Sql dba
how many columns can be used for creating index? : Sql dba
Does pl/sql support create command?
does sql support programming? : Sql dba
Why stored procedures are faster than query?
How can we make an if statement within a select statement?
how to select unique records from a table? : Sql dba
What are some emotional triggers?
Which is faster subquery or join?
What is a pdo connection?
What is database white box testing and black box testing?
Is natural join and inner join same?
Is sql procedural language?
How to run pl sql program in mysql?
How to install oracle sql developer?