Changing Standalone Stored Subprograms

To change a standalone stored subprogram, use either the SQL Developer tool Edit or the DDL statement ALTER PROCEDURE or ALTER FUNCTION.

To change a standalone stored subprogram using the Edit tool:

1. On the Connections tab, expand hr_conn.

   Under the hr_conn icon, a list of schema object types appears.

2. Expand either Functions or Procedures.

   A list of functions or procedures appears.

3. Click the function or procedure to change.

   To the right of the Connections pane, a frame appears. Its top tab has the name of the subprogram to change. Under the top tab are subtabs.

4. Click the subtab Code.

   The Code pane appears, showing the code that created the subprogram to change.

5. Click the icon Edit.

   Another pane appears, also with the name of the subprogram to change.

6. In the pane, change the code.

   The title of the pane changes to italic font, indicating that the change is not yet saved in the database.

7. Select Save from the File menu.

   Oracle Database compiles the subprogram and saves it. The title of the pane is no longer in italic font.