Is it possible to use Transaction control Statements such a
ROLLBACK or COMMIT in Database Trigger ? Why ?

Answers were Sorted based on User's Feedback



Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ..

Answer / chintu

It is not possible. but if we want to put we use autonomous
transaction.

Is This Answer Correct ?    13 Yes 0 No

Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ..

Answer / deva

yes we cannot make TCL commands with in triggers. If the
block is declared as a autonomous transaction, then commit
and rollback can be given in the end of the block

Is This Answer Correct ?    6 Yes 1 No

Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ..

Answer / 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

Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ..

Answer / nishi

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 ?    0 Yes 0 No

Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ..

Answer / tulsi

It is not possible. As triggers are defined for each table,
if you use COMMIT of ROLLBACK in a trigger, it affects
logical transaction processing.

Is This Answer Correct ?    4 Yes 7 No

Post New Answer

More SQL PLSQL Interview Questions

How many subqueries can be nested in a statement?

0 Answers  


How do I partition a table in sql?

0 Answers  


How to remove duplicate rows from a table?.

3 Answers  


is it possible to pass an object or table to a procedure as an argument?

0 Answers  


How do I turn a list into a table?

0 Answers  


What are its different types of dbms?

0 Answers  


How do I start sql from command line?

0 Answers  


How delete all data from all tables in sql?

0 Answers  


Is trigger a stored procedure?

0 Answers  


What is the use of pl/sql table?

0 Answers  


What problem one might face while writing log information to a data-base table in pl/sql?

0 Answers  


what is meant by forward declaration in functions?

4 Answers   TCS,


Categories