Referencing Package Contents:

To reference the types, items and subprograms declared within a package specification the dot notation is to be used as given below:

package_name.type_name

package_name.item_name

package_name.subprogram_name

A Package contents can be referenced from a database trigger and a stored subprogram, an OCI application, an Oracle tool such as SQL*Plus or an Oracle Precompiler application.

For instance, the packaged procedure hire_employee may be called from SQL*Plus, as given below:

EXECUTE emp.actions.hire_employee('TATE', 'CLERK', ...); # calling a package #