1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / guest

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

What is the difference between instead of trigger and after trigger?

0 Answers  

does sql support programming? : Sql dba

0 Answers  

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.

11 Answers   Ebix, Hewitt,

what is sql optimization

1 Answers   Fidelity,

What is using in sql?

0 Answers  




what is error ora-03113: end-of-file on communication channel?

0 Answers  

define sql insert statement ? : Sql dba

0 Answers  

How can we implement rollback or commit statement in a trigger?

0 Answers  

What are the advantages of VIEW?

5 Answers  

Can we use insert statement in function?

0 Answers  

how to get a list of columns in an existing table? : Sql dba

0 Answers  

How do you handle exceptions. Give the syntax for it?

1 Answers   BCL, Microsoft,

For more SQL PLSQL Interview Questions Click Here
Categories