We are using UCCX Premium 5.0.2 database functionality. We have tested to do normal DB Read and use select statement and it's fine. However, when I tried to use store procedures function by the following query.
exec sp_name $param1 , $param2 , $param3
I always goes to the SQL Error brand in the DB Read steps.
I have tried other combination of the query for example.
exec @returnCode = sp_name @Param1 = $param1 , @Param2 = $param2 , @Param3 = $param3
But it also didn't work.
Does anyone has experiences in using store procedures in UCCX 5.0 version?