Editing a Package

When you edit a package, you can edit the code manually, perform a search and replace, and compile the package.

Editing a Package Manually

To edit a package manually:

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

Object Browser appears.
From the Object list, select Packages.
From the Object Selection pane, select a package.

The Specification appears. You can copy the code in this view for use in other tools. Note you can edit both the specification and the body fromObject Browser.
Click Edit to activate edit mode.
Click Find to perform a basic search and replace.

Note:

You can expand the Edit pane by clicking the Full Screen icon in the upper right of the pane, beneath the Create button.