Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Community Member

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.

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?

3 REPLIES
Community Member

Re: Getting SQL Errors when running Store Procedures in DB Read

Anyone has experience on this?

Bronze

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

Blair

*Please rate useful posts

Bronze

Re: Getting SQL Errors when running Store Procedures in DB Read

227
Views
0
Helpful
3
Replies
CreatePlease to create content