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 [email protected]​

MSCEWI3098

MSCEWI3100

Last modified 3mo ago