To reference the types, members, and subprograms that are declared in a package definition, use the syntax in the following example:
package_name.type_name package_name.item_name package_name.subprogram_name
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.