Package constant variable : Package Variables « Function Procedure Packages « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Function Procedure Packages
  3. Package Variables
SQL>
SQL> CREATE OR REPLACE PACKAGE cc_debug
  2  IS
  3     debug_active CONSTANT BOOLEAN := TRUE;
  4
  5     trace_level CONSTANT PLS_INTEGER := 10;
  6
  7  END cc_debug;
  8  /

Package created.

SQL>








27.12.Package Variables
27.12.1.Package constant variable
27.12.2.Cursor variable in a package
27.12.3.Serially Reusable Packages
27.12.4.Test unit for package scopes
27.12.5.Define constant in a package
27.12.6.Package level cursor variable
27.12.7.Use function to initialize the package level variable
27.12.8.Pre-filled table collection of varchars in a package
27.12.9.Private field
27.12.10.Use package to define variable and use across code blocks
27.12.11.Demonstrate using a packaged ref cursor for passing sets