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