DB2 Version 10.1 for Linux, UNIX, and Windows

Referencing package objects (PL/SQL)

References to objects that are defined within a package must sometimes be qualified with the package name.

To reference the objects that are declared in a package specification, specify the package name, a period character, and then the name of the object. If the package is not defined in the current schema, specify the schema name as well. For example:

package_name.type_name
package_name.item_name
package_name.subprogram_name
schema.package_name.subprogram_name

Example

The following example contains a reference to a function named GET_DEPT_NAME that is defined in a package named EMP_ADMIN:

   select emp_admin.get_dept_name(10) from dept