Oracle PL-SQL Question: Download Questions PDF
Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger? Why?
Answer:
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.
yes WE can use COMMIT and ROLLBACK triggers, but by using PRAGAMA AUTONAMOUS_TRANSATIONS. Now the transation treated as a autonomous tansation.
yes WE can use COMMIT and ROLLBACK triggers, but by using PRAGAMA AUTONAMOUS_TRANSATIONS. Now the transation treated as a autonomous tansation.
Download Oracle PL-SQL Interview Questions And Answers
PDF
Previous Question | Next Question |
How many types of database triggers can be specified on a table? What are they? | What are two virtual tables available during database trigger execution? |