IVR and SQL Stored Procedures.

[r.siddappa]

Hi,

Has any one had any luck with IVR database dips by calling a stored procedure from the IVR rather than using regualr SQL Select commands.

Thank you.

[yogeswar]

Currently IP IVR doesnot support stored procedures. You have to external create java object which can access the stored procedure and call the same from IVR script. check out the link below

http://www.cisco.com/univercd/cc/td/doc/product/voice/sw_ap_to/apps_22/dev_gd/sdkdeplo.pdf

[r.siddappa]

Yogeswar,

I just created a stored procedure and I am calling the same from the IVR. It wroks when I use the Test tab availbe in the DB read statement. I have not tested using the phone to make sure that we are getting the right data. I will let you know how the things are.

R.