Getting SQL Errors when running Store Procedures in DB Read
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.
Re: Getting SQL Errors when running Store Procedures in DB Read
Using the CRS Java bean steps, stored procedures are not supported out of the box, but a few things can be done to use them, looks like you are using SQL server... Couple options
a)create a custom Java class accessing the Stored Procedure, there are some good threads out here on custom java classess, this probably has the best 'take away' learn a useful skill while solving your problem.
b)if possible write the SQL of the underlying stored procedure and code the rest of it using CRS steps, you may learn some more CRS scripting as well as SQL
c)keep looking at the threads out here, I have seen some posts on older versions of IPCC using the DBRead and DBGet, it may work for SQL Server
I'm not able to access my old voice mail messages all of a sudden. The recording says something like 'the message is currently not available'. This has never happened before in all the years I have been using this system. I have t...