Help Center> Data Warehouse Service> Tool Guide> Data Studio - Integrated Database Development Tool> Creating Function/Procedure
View PDF

Creating Function/Procedure

Perform the following steps to create a function/procedure and SQL function:

  1. In the Object Browser pane, right-click Functions/Procedures under the particular schema where you want to create the function/procedure and select either Create PL/SQL Function or Create SQL Function or Create PL/SQL Procedure or Create C Function based on your requirement.

    Data Studio opens a new tab with the selected template.

  2. Add the function/procedure by right-clicking in the tab and selecting Compile, or choosing Run > Compile/Execute Statement from the main menu, or pressing Ctrl+Enter to compile the function/procedure.

    The Created function/procedure Successfully dialog box is displayed, and the new function/procedure is displayed under the Object Browser. Click OK to close the NewObject() tab and add the debug object in Object Browser.

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

  3. The asterisk (*) symbol next to the function/procedure name indicates that the function/procedure is not compiled or added in the Object Browser.

    You must refresh (using F5) the Object Browser to view the newly added debug object.

    • A popup message displays the status of the completed operation. The status bar does not display the status of this operation.
    • For C functions, debug operation is not supported.

Supporting Compile Function

When a new PLSQL object is generated, either from the template or by editing an existing PLSQL object, the newly created SQL object will be opened in a new tab page.

This new function will open in a new tab page.

Follow the steps to compile function:

  1. Select Function/Procedures from the Object Browser tab page.
  2. Right click Function/Procedures. A menu option is displayed.

  3. Click Create PL/SQL Function. The new function/procedure tab page is opened.

  4. Edit the code.
  5. Right click on the tab. A menu option is displayed.

  6. Click Compile. A pop-up message is displayed as follows:

    This function is displayed in a new tab.