This topic describes how to use a package.

To reference the types, items and subprograms that are declared in a package specification, you must use the dot notation. The following example is provided:


You can run the following Structured Query Language (SQL) command to call a function from the emp_admin package specification:

SELECT emp_admin.get_dept_name(10) FROM DUAL;

In this command, the get_dept_name function that is declared in the emp_admin package is called. The department number is passed as an argument to the function. This function returns the name of the corresponding department. The return value is ACCOUNTING that corresponds to department number 10.