SSC-FDM-OR0025

Not Null constraint is not supported in Snowflake Procedures

Description

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

Example Code

Input Code:

IN -> Oracle_01.sql

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

Output Code:

OUT -> Oracle_01.sql

CREATE OR REPLACE PROCEDURE PROC04 ()
RETURNS VARCHAR
LANGUAGE SQL
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"oracle"}}'
EXECUTE AS CALLER
AS
$$
 DECLARE
  var3 FLOAT := 100 /*** SSC-FDM-OR0025 - 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 [e-mail]