MSCEWI3098

Not Null constraint is not supported in Snowflake Procedures

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

Severity

Low

Description

The Oracle variable declaration NOT NULL constraint is not supported in variable declarations inside procedures in Snowflake.

Example Code

Input Code:

CREATE OR REPLACE PROCEDURE PROC04
IS
 var3 FLOAT NOT NULL := 100;
BEGIN
	NULL;
END;

Output Code:

CREATE OR REPLACE PROCEDURE PUBLIC.PROC04 ()
RETURNS VARCHAR
LANGUAGE SQL
EXECUTE AS CALLER
AS
$$
   DECLARE
      var3 FLOAT := 100 /*** MSC-WARNING - MSCEWI3098 - NOT NULL CONSTRAINT IS NOT SUPPORTED BY SNOWFLAKE ***/;
   BEGIN
      NULL;
   END;
$$;

Recommendations

• No end-user action is required.

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