Creating Packages With the Object Browser Page

Previous

Next

You can use the Object Browser page to create packages. This section explains how to create a package specification.

To create a package specification:

1. Log in to the Database Home Page. See "Logging in to the Database Home Page".

2. On the Database Home Page, click the Object Browser icon.

3. In the Detail pane, select Package from the Create menu.

4. In the Create Package page, select the Specification option and click Next.

5. Enter the package name (emp_actions_new), and then click the Next button.

6. Enter the PL/SQL source code for the package specification. Use the code in Example: Creating a Package Specification.

7. After entering the code for the package specification, click the Finish button.

8. Click the Body tab, then the Edit button to enter the source code for the package body. Use the code in Example: Creating a Package Body, substituting emp_actions_new for emp_actions.

9. Click the Compile button to run the package. If errors are raised, correct the source code and try compiling again. Compiling the package also saves any changes made to the package.

10. When you have finished, click the Finish button.

In the previous steps, you created a package. For information about how to execute or call a subprogram in the package, see "Calling Procedures and Functions in Packages".