| |
GeekInterview.com > Interview Questions > Oracle > PL/SQL
| Print | |
Question: TCL Statements in Trigger
Answer: Why are we not supposed to include TCL statements in a trigger? |
| March 03, 2009 01:42:54 |
#2 |
| bharadwaj.uma |
Member Since: March 2009 Total Comments: 2 |
RE: TCL Statements in Trigger
|
| A Trigger may not issue any transactional control statements-COMMIT, ROLLBACK or SAVEPOINT. The trigger is fired as part of the execution of the triggering statement and is in the same transaction as the triggering statement. When the triggering statement is committed or rollback, the work in the trigger is committed or rollback as well. |
| |
Back To Question | |
