Editing a Function/Procedure

Perform the following steps to edit a function/procedure or SQL function:

1. In the Object Browser pane, double-click or right-click the required function/procedure or SQL function and select View Source. You must refresh Object Browser to view the latest DDL.

   The selected function/procedure or SQL function is displayed in the PL/SQL Viewer tab page.

   

   If multiple functions/procedures or SQL functions have the same schema, name, and input parameters, only one of them can be opened at a time.

2. After editing or updating, compile and execute the PL/SQL program or SQL function. For details, see Executing a Function/Procedure.

   If you execute the function/procedure or SQL function before compilation, the Source Code Change dialog box is displayed.

3. Click Yes to compile and execute the PL/SQL function/procedure.

   The status of the completed operation is displayed in the Message tab page.

   Refer to Executing SQL Queries for information on reconnect option in case connection is lost during execution.

4. After compiling the function/procedure or SQL function, press F5 to refresh Object Browser to view the updated code.