MSCEWI3099

The exception code exceeds the Snowflake Scripting limit

Severity

Low

Description

This warning appears when an exception declaration error code exceeds the Snowflake Scripting exception number limits. The number must be an integer between -20000 and -20999.

Example Code

Input Code:

CREATE OR REPLACE PROCEDURE procedure_exception
IS
my_exception EXCEPTION;
PRAGMA EXCEPTION_INIT ( my_exception, -19000 );
BEGIN
    NULL; 
END;

Output Code:

CREATE OR REPLACE PROCEDURE PUBLIC.procedure_exception ()
RETURNS VARCHAR
LANGUAGE SQL
EXECUTE AS CALLER
AS
$$
   DECLARE
      my_exception EXCEPTION /*** MSC-WARNING - MSCEWI3099 - EXCEPTION CODE NUMBER EXCEEDS SNOWFLAKE SCRIPTING LIMITS ***/;
   BEGIN
      NULL;
   END;
$$;

Recommendations

  • Check if the exception code is between the limits allowed by Snowflake Scripting, if not change it for another exception number available.

  • If you need more support, you can email us at snowconvert-support@snowflake.com