Creating PL/SQL Package Bodies

Bodies for PL/SQL packages can be created in the database through a JDBC connection. You cannot create a body for a package that already has one.

To create a package body:

Select View Connection Navigator.
Expand Database and select a database connection.
In the connection, select and expand a schema.
In the schema, expand the Packages node.
Right-click the package for which the body will be created, and choose New PL/SQL Package.
Type a valid package name in the Create PL/SQL Package dialog and click OK.
A skeleton definition is created and opened in the Code Editor. Edit it to define the body.