Maintaining Stored Procedures

Procedure

1. Choose Configuration Center > Flow Configuration > Intelligent IVR.
2. Choose Resource Management > Stored Procedure and click Add in the upper right corner.
3. 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.

4. 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))

5. Click the Output Parameter tab. Click Add and configure the output parameters of the stored procedure one by one.
6. Click Confirm.
7. 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.

8. Click Confirm.