MSCEWI3054

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

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