UPDATE_ERROR_VARS_UDF (STRING, STRING, STRING)

Definition

This user-defined function (UDF) updates the error variables in an environment in order to know when the procedure throws an error.

UPDATE_ERROR_VARS_UDF(MESSAGE STRING, SEVERITY STRING, STATE STRING) 

Parameters

STATE STRING

The state of the error message.

MESSAGE STRING

The message to be shown in the error.

SEVERITY STRING

The severity of the error.

Returns

Returns a string value with the new error message information.

Usage example

Input:

  SELECT UPDATE_ERROR_VARS_UDF('Message', '1', '1');

Output:

1ABC1