03-07-2011 01:30 PM - edited 03-14-2019 07:31 AM
I am attempting to use a DB Read step to execute a stored procedure on UCCX 8. When I attempt to save the Read step I get an error for every variable I have in the SQL statement. When removing the variables and hardcoding the information there is no issue. Customer is getting antsy. Any help would be appreciated.
Here is the SQL statement.
DECLARE @return_status int
EXECUTE @return_status = BEGIN.BEPA $strAcctNum, $strCustNum, $decBalance, $strFinalExtension, 'Entered through IVR', 0;
SELECT 'Return_Status' = @return_status
PS
I am not very well versed in SQL.