SSC-EWI-OR0097

Procedure Properties are Not Supported in Snowflake Procedures

Severity

Low

Description

Oracle CREATE PROCEDURE additional properties are not required and have no equivalent by Snowflake CREATE PROCEDURE.

Example Code

Input Code Oracle:

IN -> Oracle_01.sql

CREATE OR REPLACE PROCEDURE PROC01
DEFAULT COLLATION USING_NLS_COMP
AUTHID CURRENT_USER
ACCESSIBLE BY (PROCEDURE PROC03)
AS
BEGIN
    NULL;
END;

Output Code:

OUT -> Oracle_01.sql

CREATE OR REPLACE PROCEDURE PROC01 ()
RETURNS VARCHAR
LANGUAGE SQL
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"oracle"}}'
EXECUTE AS CALLER
!!!RESOLVE EWI!!! /*** SSC-EWI-OR0097 - PROCEDURE PROPERTIES ARE NOT SUPPORTED IN SNOWFLAKE PROCEDURES ***/!!!
AS
$$
    BEGIN
        NULL;
    END;
$$;

Recommendations

• No end-user action is required.

• If you need more support, you can email us at [e-mail]