To reference the types, members, and subprograms that are declared in a package definition, use the syntax in the following example:

To call a function from the emp_admin package definition, run the following Structured Query Language (SQL) command:
SELECT emp_admin.get_dept_name(10) FROM DUAL;

In this command, the get_dept_name function 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 of this function is ACCOUNTING that corresponds to the department number 10.