Editing a Procedure

When you edit a procedure you can edit the code manually or perform a search and replace.

Editing a Procedure Manually

To edit a procedure manually:

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

Object Browser appears.
From the Object list, select Procedures.
From the Object Selection pane, select a procedure.

The Code view appears. You can edit the code in this view.
Click Find & Replace to perform a basic search and replace.