MSCEWI3034

Package procedure declaration heading is not necessary for Snowflake.

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