Traps
There is no direct way of knowing if a DISCONNECT
or TRANSACTION ROLLBACK
trigger caused an exception.It also follows that the connection to the database cannot happen if a CONNECT
trigger causes an exception and a transaction cannot start if a TRANSACTION START
trigger causes one, either.Both phenomena effectively lock you out of your database until you get in there with database triggers suppressed and fix the bad code.