Oracle and PL/SQL Recipes: A Problem-Solution Approach

12-10. Creating a Package Header and Body

Problem

You want to create a package and store it into the database using Oracle SQL Developer.

Solution

Use the Create Package Wizard, or type the PL/SQL package code into a SQL worksheet. To start the wizard, go to the File menu, and select the New option. Once the Create a New dialog box opens, select Package, as shown in Figure 12-29.

Figure 12-29. Creating a new package

Once you click OK, you will be prompted to select a database connection. This will open the Create PL/SQL Package Wizard. Alternatively, you can connect to the database of your choice and then expand the navigator so that all the ...