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
Answer / chintu
It is not possible. but if we want to put we use autonomous
transaction.
Is This Answer Correct ? | 13 Yes | 0 No |
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 |
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 |
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 |
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 |
I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?
is mysql query is case sensitive? : Sql dba
How is a PL/SQL code compiled?
Write a simple program on cursors
why we go for package? what are the advantages of using instead of seperate procuderes or functions
What is sql analyzer?
What are the different type of joins in sql?
How do you change a value in sql?
what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...
Can we write ddl statements in functions?
Why is pl sql used?
How do you declare a constant?