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

Support for global package variables

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Duplicate
    • N/A
    • 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

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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