Home -> Usenet -> comp.databases.oracle -> Sequence of Triggers

Sequence of Triggers

From: deejay <djuravel_at_dgny.com>
Date: 4 Dec 2001 06:22:31 -0800
Message-ID: <f7b19882.0112040622.53076da0_at_posting.google.com> 






I've learnt from previous deja discusssions that one way to get around
the "Table Mutating...Any changes made made be lost" problem is to
make 2 triggers. One being the row trigger which saves the new data of
a specific row, and the other being the statement trigger which
actually executes the updates for each row based the the saved values.
One thing I'm not clear on: When updating a table with these 2
triggers, what is the sequence of the firing of these triggers? Is the
row trigger fired and then the statement trigger immediately fired
after that row trigger was fired --for each row, or does the row
trigger get fired for each row and then at the end, just once the
statement trigger gets fired?
Received on Tue Dec 04 2001 - 15:22:31 CET












Original text of this message