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?