cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
512
Views
0
Helpful
3
Replies

Getting SQL Errors when running Store Procedures in DB Read

ibm.alexl
Level 1
Level 1

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 3

ibm.alexl
Level 1
Level 1

Anyone has experience on this?

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

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: