VoiceGuide IVR Software Main Page
Jump to content

Sql Stored Proc Question

Recommended Posts

I am new to voiceguide and im running into a little problem right now with an sql call. I am using the Database Query module with and ODBC connection.

 

My SQL Query is 'exec ivr_hti_phoneval 4107320887'

 

The stored procedure is supposed to return 5 values. How can I store and retrieve these values to RV?

 

I would really appreciate any help.

 

Thanks

Share this post


Link to post

If I was to use the Database Query tool with the ODBC connection and not use VBscript how can I store the returned results from a stored procedure?

 

 

182206.27 6 fn RunModule start

182206.27 6 tw DialogicEvent 129,TDX_PLAY,30953,0,0,,,

182206.28 6 event TDX_PLAY, code=129, state=6001

182206.28 6 timer clear

182206.28 6 state [Database Query 20] DB Query

182206.28 6 db ODBC mode used

182206.31 6 db About to execute a Retrieve type operation [exec ivr_hti_phoneval 4107320887]

182206.31 6 rv add [Database Query 20_RowCount]{0}

182206.33 6 db [Database Query 20] movelast err :

182206.33 6 rv add [Hangup Time]{9/14/2005 6:22:06 PM}

182206.33 6 state Hanging up call... [Fail/False path not defined]

182206.33 6 HangupCall_Common hCall=6

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×