Overview
Log on to OceanBase Developer Center (ODC) and click the name of the target connection to go to the corresponding connection management page. You can click Stored Procedure in the left-side navigation pane to get a list of stored procedures. To create a stored procedure, click + in the upper-right corner of the Stored Procedure list or choose Create > Stored Procedure in the top navigation bar. The following table describes the parameters that you need to specify to create a stored procedure.
Parameters
| Parameter | Description |
|---|---|
| Name | Specifies the name of the stored procedure. |
| Parameter | Specifies the information passed to the stored procedure when the stored procedure is called. You need to specify different parameters in different modes: In Oracle mode, specify Name , Mode , Type , and Default Value . In MySQL mode, specify Name, Mode, Type , and Length . Note * You can drag the parameters to adjust their orders. * In the quick access toolbar, you can add, delete, and move up and down the parameters. * You can click a row number to select a row and display the quick access toolbar that allows you to delete the entire row of parameters or move them upward or downward. * You can perform the following right-click operations: * Copy a row: Drag the pointer to select a row, right-click it, and then select Copy from the context menu that appears. * Copy a cell: Select a cell, right-click it, and then select Copy from the context menu that appears. * You can click a row number to select a row, and then drag the row to adjust the orders of the entire row of parameters. * Click OK to go to the Create Function page. |
Parameter modes
You need to specify the mode for the parameters. The following parameter modes are supported: IN , OUT , and INOUT .
| Mode | Description |
|---|---|
| IN | Indicates an input parameter. When a stored procedure is called, the input parameter is passed to the stored procedure and used in the execution of the stored procedure. |
| OUT | Indicates an output parameter. When a stored procedure is called, the value of an output parameter is ignored and an empty value is passed to the stored procedure. The value of the output parameter is modified during the execution of the stored procedure. After the execution is complete, the modified value is assigned to output parameter. Usually, output parameters are used to obtain the execution results of a stored procedure. |
| INOUT | Indicates an inout parameter. An inout parameter is both an input parameter and an output parameter. |
Parameter settings
| Property | Required | Default | Mode |
|---|---|---|---|
| Name | Yes | Empty | Oracle/MySQL |
| Mode | Yes | IN | Oracle/MySQL |
| Type | Yes | VARCHAR | Oracle/MySQL |
| Length | Yes | 45 | Oracle/MySQL |
| Default Value | No | Empty | Oracle/MySQL |