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 folder.
Right-click a package for which the body will be created
Choose New PL/SQL Package from the context menu. .
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.