Database Access in Error Handlers
If your error handler performs database access (for example, logs errors to a table), the error handler must explicitly set the connection upon entry and restore the original connection before exiting. For details about handling errors in Ingres SQL, see the SQL Reference Guide.
Note: To avoid the overhead of database access in a TP environment, consider logging errors to flat files.