Subject Transactions & exception trapping
Author Rick Debay
I have a table with before and after insert triggers. I also have a
stored procedure that loops, inserting rows in to the table. The last
statement in the loop is WHEN ANY to catch and log errors to an external
table and continue looping.

If an insert trigger throws an exception, will the insert be rolled back
even though I'm catching the exception and continuing? Or will this
subvert the triggers and allow inconsistent data?