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 edit the code in this view.
Click Find & Replace to perform a basic search and replace.