cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
111
Views
5
Helpful
2
Replies
Highlighted
Beginner

UCCX How to call a stored procedure

I need to run the following stored procedure call in my scrip. This returns a string.  

 

Select DISTINCT family from dbo.fx_site( '"+ID+"' ) where child_level=1

 

'dbo.fx_site' is a stored procedure. So if I do a 'Test' in DB Read step nothing gets returned and I am unable to map the fields in DB Get step since the stored procedure is not available in the 'Table/View' drop down. Contact Center

Can someone please help me withe procedure on calling a stored procedure?

 

Thanks in advance.

 

 

Everyone's tags (1)
2 REPLIES 2
Highlighted
Beginner

Re: UCCX How to call a stored procedure

I started writing java code in Do step to accomplish this. I have successfully tested the code in eclipse. When I add the code to my UCCX script, I get the following error. The driver is added Subsystems->Database->Drivers. What am I missing here?

I also have a DB Read step added and it retrieves the data successfully. 

 

.DriverError.JPG

 

Highlighted
Beginner

Re: UCCX How to call a stored procedure

Got it to work by removing the following line.

 

Class.forName("net.sourceforge.jtds.jdbc.Driver");

CreatePlease to create content
Content for Community-Ad
Future of Work Virtual Summit Day 5

Cisco COVID-19 Survey