MSC-PG0014

Raise Exception translated to user-defined stored procedure call and raise stat.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Low

Description

This warning is added because a Raise Exception was found inside an Exception Block. Since we are inside an Exception Block, we can add a Raise statement.

Code Example

Input Code:

PostgreSQL

EXCEPTION 
    WHEN OTHERS THEN
    RAISE EXCEPTION '% - %',v_var1, v_var2;

Output Code:

Snowflake

EXCEPTION
    WHEN OTHER THEN
    SC_RAISE_MESSAGE := STRING_FORMAT_UDF('% - %', array_construct(:v_var1, :v_var2));
    --** MSC-WARNING - MSC-PG0014 - RAISE EXCEPTION TRANSLATED TO USER-DEFINED STORED PROCEDURE CALL AND RAISE STAT **
    CALL RAISE_MESSAGE_UDF('EXCEPTION', :SC_RAISE_MESSAGE);
    RAISE;

Recommendations

• If you need more support, you can email us at [email protected]