Editing a Function/Procedure

Follow the steps below to open and edit the function/procedure or SQL function:

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

   The function/procedure or SQL function based on your selection is displayed.

   

   Only one function/procedure or SQL function with the same schema, name, and input parameters can be opened in Data Studio.

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

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

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

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

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

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