Table of Contents Previous Next


2 Packages : 2.3 Referencing a Package

package_name.type_name
package_name.item_name
package_name.subprogram_name
To invoke a function from the emp_admin package specification, we will execute the following SQL command.
Here we are invoking the get_dept_name function declared within the package emp_admin. We are passing the department number as an argument to the function, which will return the name of the department. Here the value returned should be ACCOUNTING, which corresponds to department number 10.

2 Packages : 2.3 Referencing a Package

Table of Contents Previous Next