TechView with Kamlesh khaliya

Resources for OCP, Oracle Interviews(kamleshkhaliya@gmail.com)

Wednesday 14 March 2012

Can we use commit in Oracle triggers?



In normal triggers you can't use transaction control statement like commit, rollback and can't use DDL because DDLs are auto commit in nature. This is not allowed because if you are allowed to commit a transaction in trigger then you are committing the work done by trigger as well the main transaction by which the trigger was fired. So this will introduce inconsistency in data.

Where as Autonomous trigger can use Transaction control and DDL because autonomous transaction can commit itself with out committing the parent transaction. You can define autonomous triggers and procedures, functions also.

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home