Add support for Package Body Constants (or even Variables)
----------------------------------------------------------

                 Key: CORE-6538
                 URL: http://tracker.firebirdsql.org/browse/CORE-6538
             Project: Firebird Core
          Issue Type: Improvement
          Components: Engine
            Reporter: Anderson Farias
            Priority: Minor


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

(...)



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to