Is it possible to use Transaction control Statements such a
ROLLBACK or COMMIT in Database Trigger ? Why ?
- 5 Answers
- 15989 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what is a record in a database ? : Sql dba
What does a pl/sql package consist of?
how to get a list of columns in an existing table? : Sql dba
What is lexical units in pl sql?
What is the difference between a database and a relational database?
Why truncate is faster than delete?
The select into statement is most often used to create backup copies of tables or for archiving records?
What is the purpose of cursors in pl/sql?
What is sql prepared statement?
What are the types of subqueries?
What is mutating error in pl sql?
How to install oracle sql developer?
Can we debug stored procedure?
What is rank dense_rank and partition in sql?
What is trigger explain it?
