cancel
Showing results for 
Search instead for 
Did you mean: 
cancel

Who Me Too'd this topic

How to execute a Stored Procedure

anthoney_murphy
Level 1
Level 1

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.

Who Me Too'd this topic