great discussion...on rollback.

what about the scenario...where

* one trigger does updates other tables

* another trigger does updates to some other tables

* what will happen if there is rollback in one of them that kicks in....will it stop the next trigger from running.....or will the next trigger go on and do its thing.

Because you mentioned the triggers fire in no order...