Maintaining Stored Procedures
The system supports the MySQL, Oracle, and GaussDB stored procedures. The stored procedures must be predefined.
Procedure
- Choose .
- Choose Add in the upper right corner. and click
- Enter the basic information about the stored procedure.
Set Storage Procedure based on the function description and set Value to the name of an existing stored procedure in the database.
- Click the Input Parameter tab. Click Add and configure the input parameters of the stored procedure one by one.
The input parameters of a stored procedure are usually in the same line as CREATE PROCEDURE and are identified by IN. For example, four input parameters are defined in the following stored procedure definition, where varchar corresponds to the Character data type in the system.
CREATE PROCEDURE p_modify_column_name (in tableName varchar(128), in oldName varchar(128), in newName varchar(128), in incolumnType varchar(128))
- Click the Output Parameter tab. Click Add and configure the output parameters of the stored procedure one by one.
- Click Confirm.
- On the Stored Procedure Databases tab page, click Add to configure the database connection information of the stored procedure. If this information has been configured, click Edit.
- Database Type: The options are MySQL, GaussDB, and Oracle. Select a value based on site requirements.
- Database Driver: driver used for connecting to the database. Generally, you do not need to set this parameter.
- Database URL: database connection string, which is a JDBC connection string. Contact the administrator to add it to the trustlist.
Table 1 Configuration format of the database connection string Database
Configuration Format
Configuring Example
MySQL
jdbc:mysql://IP address:Port number/SID
jdbc:mysql://IP address:Port number/oiap?autoReconnect=true&useServerPrepStmts=true&cachePrepStmts=true&useUnicode=true&characterEncoding=utf-8&useSSL=false
GaussDB
jdbc:zenith:@IP address:Port number:SID
jdbc:zenith://IP address:Port number/oiap
Oracle
jdbc:oracle:thin:@Host IP address:Port number:SID
jdbc:oracle:thin:@IP address:Port number:oiap
- Database User and Database Password: username and password for connecting to the database.
If the database password provided by the third-party system is changed periodically, return to this page and click Edit to change the database password correspondingly.
- Click Confirm.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot