Sql Stored Proc Question

[BrianW]

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

[SupportTeam]

There are some examples of how to do stored procedure calls at the bottom of this help file page: http://www.voiceguide.com/vghelp/html/modVbs.htm

 

To return values to VoiceGuide use any of these:

http://www.voiceguide.com/vghelp/html/com_RvSet.htm

http://www.voiceguide.com/vghelp/html/com_...vSet_RvList.htm

http://www.voiceguide.com/vghelp/html/com_...cript_Gosub.htm

http://www.voiceguide.com/vghelp/html/com_...Script_Goto.htm

http://www.voiceguide.com/vghelp/html/com_...ript_Return.htm

[BrianW]

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

[SupportTeam]

Stored procedure calls can only be made from within VBScript.

[BrianW]

thanks for your help