09-01-2008 03:36 AM - edited 03-14-2019 02:48 AM
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?
09-01-2008 08:51 PM
Anyone has experience on this?
09-02-2008 09:32 AM
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
09-11-2008 07:20 AM
Look at the following post, that should help you.
http://forum.cisco.com/eforum/servlet/NetProf?page=netprof&forum=Unified%20Communications%20and%20Video&topic=Contact%20Center&topicID=.ee6fe12&CommCmd=MB%3Fcmd%3Dpass_through%26location%3Doutline%40^1%40%40.1ddd8f26/2#selected_message
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide