ERROR_MESSAGE( )

VARCHAR containing the error message of the error that invoked the CATCH block.

Call this function anywhere within a CATCH block. This function returns the active error message anywhere in the error handler, while the ERRORMSG function, when called with no parameters, only returns the error message when invoked in the first statement of the error handler.

The parameters in the error message are replaced with actual values.

• TRY statement
• BEGIN statement
• ERROR_LINE function [Miscellaneous]
• ERROR_PROCEDURE function [function type]
• ERROR_SQLCODE function [Miscellaneous]
• ERROR_SQLSTATE function [Miscellaneous]
• ERROR_STACK_TRACE function [Miscellaneous]
• STACK_TRACE function [Miscellaneous]
• sa_error_stack_trace system procedure
• sa_stack_trace system procedure
• Nested compound statements and exception handlers
• Example: Creating an error logging procedure that can be called by an exception handler

When executed within a handler that was invoked by a division by zero error on line 15 of the procedure u1.proc1, the following statement SELECT ERROR_LINE(), ERROR_MESSAGE(), ERROR_PROCEDURE() returns the following result:

15, 'Division by zero',  '"u1"."proc1"'