SSC-FDM-OR0007

Snowflake does not support the versioning of objects. Developers should consider alternate approaches for code versioning.

Description

Snowflake doesn't support the versioning of objects. The modifier EDITINONABLE or NONEDITIONABLE is removed in the converted code and a warning is added.

Example Code

Input Code:

IN -> Oracle_01.sql
CREATE OR REPLACE EDITIONABLE PROCEDURE FUN1 (n number)is
l_result number;
begin
    DELETE FROM employees;
end;

Output Code:

OUT -> Oracle_01.sql
--** SSC-FDM-OR0007 - SNOWFLAKE DOESN'T SUPPORT VERSIONING OF OBJECTS. DEVELOPERS SHOULD CONSIDER ALTERNATE APPROACHES FOR CODE VERSIONING. **
CREATE OR REPLACE PROCEDURE FUN1 (n NUMBER(38, 18))
RETURNS VARCHAR
LANGUAGE SQL
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},"attributes":{"component":"oracle"}}'
EXECUTE AS CALLER
AS
$$
    DECLARE
        l_result NUMBER(38, 18);
    BEGIN
        DELETE FROM
            employees;
    END;
$$;

Recommendations

Last updated