MSCEWI3034
Package procedure declaration heading is not necessary for Snowflake.
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
Severity
Low
Description
This warning is added when there is a Package Declaration with Stored Procedures. The Stored Procedure translation is done using the Package Body definition so the declarative part is not necessary for the transformation.
Example Code
Input Code:
CREATE OR REPLACE EDITIONABLE PACKAGE MY_PACKAGE AS
PROCEDURE MY_PROCEDURE(PARAM1 VARCHAR2);
END;
Output Code:
CREATE SCHEMA IF NOT EXISTS MY_PACKAGE;
/*** MSC-WARNING - MSCEWI3034 - PACKAGE PROCEDURE DECLARATION HEADING IS NOT NECESSARY IN SNOWFLAKE ***/
/* PROCEDURE MY_PROCEDURE(PARAM1 VARCHAR);*/;
The package body will be converted.
Input Code:
CREATE OR REPLACE EDITIONABLE PACKAGE BODY MY_PACKAGE AS
PROCEDURE MY_PROCEDURE(PARAM1 VARCHAR2) AS
-- MORE STATEMENTS...
END GRANT_TAB_PRIVS;
END MY_PACKAGE;
Output Code:
CREATE OR REPLACE PROCEDURE MY_PACKAGE.MY_PROCEDURE(PARAM1 STRING)
RETURNS STRING
LANGUAGE JAVASCRIPT
EXECUTE AS CALLER
AS
$$
// MORE STATEMENTS...
$$;
Recommendations
No additional user actions are required.
If you need more support, you can email us at [email protected]
Last updated