Manage stored procedures

Overview

After you log on to OceanBase Developer Center (ODC), you can click the name of a connection on the homepage to go to the corresponding connection management page. In the left-side navigation pane, you can click Stored Procedure to get a list of stored procedures in the current database.

In the stored procedure list, you can view the structure tree of an object, or right-click the object to perform some management actions on the object. You can also double-click the name of the stored procedure in the list to go to the stored procedure management page .

Structure tree

You can click the expand icon before the name of the target stored procedure in the stored procedure list, and the structure tree of the stored procedure is displayed in a drop-down list, as shown in the following figure.

The structure tree of a stored procedure can have up to three levels. When you right-click an item in the tree, the shortcut menu displays some actions that you can perform on the item. For more information about these actions, see the Management actions section. In this section, you can find the table describing the management options.

Management actions

Right-click the target object in the structure tree. A shortcut menu appears, displaying some management options provided by ODC for you to conveniently manage the target object.

The following table describes the management options.

Stored procedure management page

You can double-click the name of a stored procedure in the function list to go to the stored procedure management page. The stored procedure management page displays the following information:

Section	Description
Basic Information	This section displays the basic information about the stored procedure in fields such as Stored Procedure Name , Created By , Creation At , and Last Modified At .
Parameter	This section displays the information about the parameters in fields such as Name , Mode , Data Type , Length , and Default Value .Click the icon to refresh the parameters.
DDL	This section displays the script that defines the stored procedure and provides the Edit , Find , Format , and Refresh buttons. Note Click the Edit icon to go to the PL object editing page.

Stored procedure editing page

Right-click the target item in the stored procedure list. In the menu that appears, click Edit to go to the stored procedure editing page. In the code area of the editing page, the statements that define the stored procedure are displayed. You can edit the statements. In addition, the toolbar provides the following buttons:

Stored procedure output page

After the stored procedure is executed, you can view the information of execution results in the Output and DBMS Output tabs.