UCCX How to call a stored procedure

[Nliya53887]

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.

[Nliya53887]

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. 

.

[Nliya53887]

Got it to work by removing the following line.

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