Hi,

 

If you need to update same table then „before” update trigger is the best choice.

 

>>Updating another table from a Before trigger is made in a transaction

>>that rolling back if exception occurs?

 

If you do not run it in different transaction context - like IN AUTONOMOUS TRANSACTION - then yes

Ok, I think I asked an incorrect question
I could explain better:
Updating another table from a Before trigger is made in a transaction that rolling back if exception occurs even I have hundred rows in table that fire a before insert/update trigger and if the exception occurs in hundredth row? or trigger is fired row by row in table and this behaviour not occurs and the update made by row 1..99 are confirmed even occurs an exception in row 100?

Thanks.
--

Luigi Siciliano
--------------------------