Lets say i have the following code:

StoredProcedure.SQL.Clear;
StoredProcedure.StoredProcName := 'MY_SP';
.....
TheTransaction.StartTransaction;
try
StoredProcedure.ExecProc;
TheTransaction.Commit;
except
on E: Exception do
TheTransaction.Rollback;
end;

Is there a way to get to IB_Connection.OnError event handler in case
of network failre, despite of this try..except block?

Maybe this should be handled in Transaction.OnError handler?

Thanks.