MSCEWI3054

Package constants in the stateful package are declared inside the procedure or functions that use them.

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

Severity

Low

Description

This warning is related to the package constants declaration and is used to notice that the constants will be declared inside the procedures or functions that use them.

Example Code

Input Code:

CREATE OR REPLACE PACKAGE PACKAGE_CONSTANTS
IS
name CONSTANT VARCHAR(10) := 'Snow';
END PACKAGE_CONSTANTS;

Output Code:

CREATE SCHEMA IF NOT EXISTS PACKAGE_CONSTANTS;
/*** MSC-WARNING - MSCEWI3054 - PACKAGE CONSTANTS IN STATEFUL PACKAGE ARE DECLARED INSIDE THE PROCEDURE OR FUNCTIONS THAT USE THEM ***/
  /*name CONSTANT VARCHAR(10) := 'Snow';*/;

Recommendations

• Not end-user actions are required.

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