Distributed Transaction Processing User Guide > Distributed Transaction Processing User Guide > Programming Ingres DTP Applications > How Ingres DTP Applications Handle Errors > Database Access in Error Handlers
Was this helpful?
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.
Last modified date: 11/28/2023