Submitted by: Anderson Farias (afarias)

Votes: 1

It would be nice to declare CONSTANTS in package body (or even variables) that could be used by all functions/procedues with in it. Eg.

RECREATE PACKAGE BODY MY_PACKAGE
AS
DECLARE MY_CONSTANT VARCHAR(10) = 'SOME VALUE';
BEGIN

FUNCTION MY_FUNCTION_A RETURNS VARCHAR(10)
AS
BEGIN
RETURN MY_CONSTANT;
END

FUNCTION MY_FUNCTION_B RETURNS VARCHAR(50)
AS
DECLARE MY_LOCAL_VAR VARCHAR(20);
BEGIN
MY_LOCAL_VAR = 'OTHER VALUE';
RETURN MY_CONSTANT || MY_LOCAL_VAR;
END

(...)