Answer Detail: RE: TCL Statements in Trigger

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?

September 09, 2008 11:49:49	#1
srinivas_oracle	Member Since: September 2008 Total Comments: 1
RE: TCL Statements in Trigger
Directly we cannot give TCL commands in triggers. But by using pragma autonomous_transaction we can give TCL commands in triggers. hope this answer satisfies you.