Maintaining Stored Procedures

Prerequisites

• Some operations under the current menu are controlled by separate permissions. If related operation permissions are not configured, the corresponding operations are not supported. For details about the operation permissions that can be configured separately, see Table 1.
• The system supports the MySQL, Oracle, and GaussDB stored procedures. The stored procedures must be predefined.
• The administrator has added the domain name or IP address to the trustlist under Call Center > Address Trustlist in the AICC.

Procedure

1. Choose Configuration Center > Chatbot Management > Flow Configuration.
2. Choose Resource > Stored Procedure, click the Stored Procedure Databases tab, and click to configure the database connection information of stored procedures. If this information has been configured, click Edit. A maximum of 200 records are allowed.
   Figure 1 Create Stored Procedure Database page
   
   • Database Name: Database name. The value can contain only letters, digits, spaces, underscores (_), and single quotation marks (').
   • 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 and can be an IP address or a domain name. Contact the administrator to add it to the trustlist.

     Table 1 Configuration format of the database connection string

     Database	Configuration Format	Configuration Example
     MySQL	jdbc:mysql://ip:port/SID jdbc:mysql:domain name	jdbc:mysql://IP:PORT/oiap?useUnicode=true&characterEncoding=utf-8&useSSL=false service-cloud.huawei.com:3306/aicc_isales
     GaussDB	jdbc:zenith:@ip:port jdbc:zenith:domain name	jdbc:zenith:@IP:PORT service-cloud.gaussdb.com:1888
     Oracle	jdbc:oracle:thin:@host:port:SID jdbc:oracle:thin:domain name	jdbc:oracle:thin:@IP:PORT:oiap service-cloud.oracle.com:1521/ora19c

   • 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.
     

     Do not use the URL of the production database of the AICC solution as the database URL.

3. Choose Resource > Stored Procedure and click in the upper right corner of the Stored Procedures tab page.
4. Enter the basic information about the stored procedure.

   

   • Stored Procedure: Enter a customized value based on the function of the stored procedure.
   • Value: Enter the name of an existing stored procedure in the database.
   • Database Connection: Select the database created in 2.

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

6. Click the Output Parameter tab. Click Add and configure the output parameters of the stored procedure one by one.
7. Click .