Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-27248

Support for global package variables

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Critical
    • Resolution: Unresolved
    • None
    • PL/SQL
    • 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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            karlsson Anders Karlsson
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.