[MDEV-27248] Support for global package variables Created: 2021-12-13  Updated: 2021-12-13

Status: Open
Project: MariaDB Server
Component/s: PL/SQL
Fix Version/s: None

Type: Task Priority: Critical
Reporter: Anders Karlsson Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

PL/SQL packages in Oracle supports global package variables, that work a bit like session local variables, except they are types and initialized by packages obviously. Local package variables are supported, but these are only accessible from inside the package itself.
An example is this:

CREATE PACKAGE pkg1 IS
    global_var INTEGER := 1;
END pkg1;
/
CREATE PACKAGE BODY pkg1 IS
    local_var INTEGER := 2;
END pkg1;
/

After this declaration, local_var can be used by a procedure or function in the package, but not outside the package. The variable global_var though is accessible even from outside the package.

The requested feature is support for global package variables, i.e. variable declared in the package specification.


Generated at Thu Feb 08 09:51:29 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.