04-01-2020 08:05 AM
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.
04-01-2020 10:32 AM - edited 04-01-2020 11:13 AM
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.
.
04-01-2020 12:24 PM
Got it to work by removing the following line.
Class.forName("net.sourceforge.jtds.jdbc.Driver");
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