MSCEWI3099
The exception code exceeds the Snowflake Scripting limit
Low
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.
CREATE OR REPLACE PROCEDURE procedure_exception
IS
my_exception EXCEPTION;
PRAGMA EXCEPTION_INIT ( my_exception, -19000 );
BEGIN
NULL;
END;
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;
$$;
- Check if the exception code is between the limits allowed by Snowflake Scripting, if not change it for another exception number available.
Last modified 3mo ago