MSCEWI3097

Procedure Properties are Not Supported in Snowflake Procedures

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

Severity

Low

Description

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

Example Code

Input Code:

CREATE OR REPLACE PROCEDURE PROC01
DEFAULT COLLATION USING_NLS_COMP
AUTHID CURRENT_USER
ACCESSIBLE BY (PROCEDURE PROC03)
AS
BEGIN
/*
    Procedure Statements
*/
END;

Output Code:

CREATE OR REPLACE PROCEDURE PUBLIC.PROC01 ()
RETURNS VARCHAR
LANGUAGE SQL
EXECUTE AS CALLER
/*** MSC-WARNING - MSCEWI3097 - PROCEDURE PROPERTIES ARE NOT SUPPORTED IN SNOWFLAKE PROCEDURES ***/
AS
$$
   BEGIN
/*
   Procedure Statements
*/
   END;
$$;

Recommendations

• No end-user action is required.

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