Scope of Oracle package level variables

oracle, plsql

Solution

The scope is at the session level. See the first sentence under the heading "Added Functionality" in the PL/SQL User's Guide and Reference

Problem

Given the following Oracle (10g) package definition: ``` create or replace PACKAGE "foo" AS bar VARCHAR2(32000) := NULL; END; ``` what is the scope of bar? Does each session get its own foo.bar, or is foo.bar global across sessions? Can you quote me chapter and verse from a reference document?

Original source