UPDATE_ERROR_VARS_UDF (STRING, STRING, STRING, STRING, STRING, STRING)

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

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(LINE STRING,CODE STRING, STATE STRING, MESSAGE STRING, PROC_NAME STRING, SEVERITY STRING) 

Parameters

LINE STRING

The line related to the error.

CODE STRING

The error code associated with the error message.

STATE STRING

The state of the error message.

MESSAGE STRING

The message to be shown in the error.

PROC_NAME STRING

The procedure name.

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('1', '1', '1', 'ABC', 'TEST', '1');

Output:

111ABCTEST1