I still hope to find the solution to the following issue.

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 failure, despite of this try..except block?

Maybe this should be handled in Transaction.OnError handler?

The fact is, i have a number of such code in application and i would
like to have some focus point to handle them all.

Thanks.