Load the Generic IVR Adapter Database Tables and Stored Procedures
•
The ces_ivr_gateway.ces script is responsible for loading various SQL files responsible for creating the Generic IVR Adapter tables and stored procedures. The ces_ivr_gateway.ces script could call some or all of the following scripts depending on how it was invoked:
•
product_retain_ivr_interface.sql - responsible for dropping and recreating the Generic IVR Adapter tables.
•
product_ivr_interface_head.sql - responsible for loading the Generic IVR Adapter stored procedure head.
•
product_ivr_interface_body.plb - responsible for loading the Generic IVR Adapter stored procedure body.
•
To create the Generic IVR Adapter tables and stored procedure, run the following command:
ces_ivr_gateway.ces -offline
Note: The command above recreates the Generic IVR Adapter table by dropping and creating it, therefore wiping out the contents of the Generic IVR Adapter tables.
•
To create the Generic IVR Adapter stored procedure without dropping and recreating the Generic IVR Adapter tables, run the following command: