To reference the types, items and subprograms that are declared within a package specification, you must use the dot notation. For example:


You can execute the following SQL statement to invoke a function from the emp_admin package specification.

SELECT emp_admin.get_dept_name(10) FROM DUAL;

This statement invokes the get_dept_name function that is declared within the package emp_admin, and passes the department number as an argument to the function. The function returns the name of the department. The returned value is ACCOUNTING, which corresponds to department number 10.