| |
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? |
| June 06, 2009 19:51:37 |
#4 |
| Vansat |
Member Since: June 2009 Total Comments: 2 |
RE: TCL Statements in Trigger
|
| We cannot use TCL statements in triggers, because using them violates the integrity of the transaction. But if we want TCL statements to be used in triggers then that can be implemented by using Autonomous i.e. by providing PRAGMA AUTONOMOUS_TRANSACTION in the beginning of the trigger. We can use these types of triggers to maintain log details of a table. |
| |
Back To Question | |
