Creating a Package
Creating and Using Packages
Developing and Using Stored Procedures 4-11
successfully compiling your package. You then need to declare these unknown
subprograms near the top of the package body, and specify them later. For this reason,
Oracle recommends that you add new elements at the end of the package specification
or body to minimize possible invalidation of dependents.
Creating a Package
You will create a package that encapsulates all the functionality necessary to perform
employee evaluations. After you create the package,
page 4-12 explains how you modify the package and to create the package body.
To create a package in SQL Developer navigation hierarchy:
1.
In the Connections navigation hierarchy, right-click Packages.
2.
Select New Package.
3.
In the Create PL/SQL Package dialog, set the following parameters:
Ensure that Schema is set to
HR
.
Set Name to
EMP_EVAL
.
Click OK.
See Also:
Oracle Database PL/SQL Language Reference for detailed information
on using PL/SQL packages
Oracle Database PL/SQL Packages and Types Reference for default
packages available with Oracle Database
