Table of Contents Previous Next


5 Packages

Advanced Server provides a collection of packages that provide compatibility with Oracle packages.
A package is a named collection of functions, procedures, variables, cursors, user-defined record types, and records that are referenced using a common qualifier – the package identifier. Packages have the following characteristics:
Certain functions, procedures, variables, types, etc. in the package can be declared as public. Public entities are visible and can be referenced by other programs that are given EXECUTE privilege on the package. For public functions and procedures, only their signatures are visible - the program names, parameters if any, and return types of functions. The SPL code of these functions and procedures is not accessible to others, therefore applications that utilize a package are dependent only upon the information available in the signature – not in the procedural logic itself.
Other functions, procedures, variables, types, etc. in the package can be declared as private. Private entities can be referenced and used by function and procedures within the package, but not by other external applications. Private entities are for use only by programs within the package.
For more information about the package support provided by Advanced Server, please see the Database Compatibility for Oracle Developers Built-in Package Guide, available at:

5 Packages

Table of Contents Previous Next