Creating a Package

To create a package:

1. On the Workspace home page, click SQL Workshop and then Object Browser.

   Object Browser appears.

2. Click Create.

3. From the list of object types, select Package.

4. Select the type of package you want to create, then click Next:

   • Specification

   • Body

   • Package with methods on database tables

5. If you select Specification:

   1. Enter a name and click Next.

      The wizard creates a dummy package specification and displays it for editing.

   2. Edit the specification and click Finish.

6. If you select Body:

   1. Select the package you want to create the body for and click Next

      The wizard creates a package body with stubbed out calls identified in the specification and displays it for editing.

   2. Edit the package body and click Finish.

7. If you select Package with methods on database tables:

   1. Enter a name and click Next.

   2. Select up to ten tables and click Next.

      The wizard creates a specification and body with insert, update, delete, and GET APIs for the selected tables. Note that you have the option to show or download the specification or body.

   3. To confirm, click Finish.