TeleFlow Forums
http://teleflow.org/phpbb/

SQL Server 2000 store procedure
http://teleflow.org/phpbb/viewtopic.php?f=10&t=366		 Page 1 of 1
Author:  saugortgarcia [ Wed May 10, 2006 2:24 pm ]
Post subject: 
Hi, I am testing a db connection and I have to run some db store procedures. I am having some trouble trying to get right with this. I am lunching a sp that retun a value, but teleflow does not capture anything. <br> <br> <br>I think my error could be in how I am building the app in teleflow, could you give me some clues? <br> <br>Teleflow log: <br> <br>enGenic TeleFlow: Build 2006.0207 <br>(c) 1994 - 2006 enGenic <br>All rights reserved. <br> <br>2006/05/10 17:15:42.578: Driver successfully opened. <br>2006/05/10 17:15:42.593: Loading language 'C:\Program Files\TeleFlow\Lang_English.dll' <br>2006/05/10 17:15:42.609: Setting system variable '@SYSDRIVE' to 'C:' <br>2006/05/10 17:15:42.609: Setting system variable '@SYSDIR' to '\VAPP\RepMan' <br>2006/05/10 17:15:42.609: TeleFlow Application: C:\VAPP\RepMan\Generica.Tap <br>2006/05/10 17:15:42.609: Ver: 0200 S/N: 00000 <br>2006/05/10 17:15:42.609: TeleFlow Procedure: > Tam\TP_Bienvenida.Tam Ver: 0200 S/N: 00000 <br>2006/05/10 17:15:42.609: TeleFlow Procedure: Tam\InputMan.Tam Ver: 0200 S/N: 00000 <br>2006/05/10 17:15:42.625: TeleFlow Procedure: Tam\Defaults.Tam Ver: 0200 S/N: 00000 <br>2006/05/10 17:15:42.625: TeleFlow Procedure: Tam\TP_Consulta.Tam Ver: 0200 S/N: 00000 <br>2006/05/10 17:15:42.625: TeleFlow Procedure: Tam\TP_ProFax.Tam Ver: 0200 S/N: 00000 <br>2006/05/10 17:15:42.625: TeleFlow Procedure: Tam\TP_Operador.Tam Ver: 0200 S/N: 00000 <br>2006/05/10 17:15:42.625: TeleFlow Procedure: Tam\TP_DBLogger.Tam Ver: 0200 S/N: 00000 <br>2006/05/10 17:15:42.625: Setting system variable '@SYSDRIVE' to 'C:' <br>2006/05/10 17:15:42.625: Setting system variable '@SYSDIR' to '\VAPP\RepMan' <br>2006/05/10 17:15:42.625: Setting system variable '@P1' to '' <br>2006/05/10 17:15:42.625: Setting system variable '@P2' to '' <br>2006/05/10 17:15:42.625: Setting system variable '@P3' to '' <br>2006/05/10 17:15:42.625: Setting system variable '@P4' to '' <br>2006/05/10 17:15:42.625: Setting system variable '@P5' to '' <br>2006/05/10 17:15:42.625: Setting system variable '@P6' to '' <br>2006/05/10 17:15:42.640: Setting system variable '@P7' to '' <br>2006/05/10 17:15:42.640: Setting system variable '@P8' to '' <br>2006/05/10 17:15:42.640: Setting system variable '@P9' to '' <br>2006/05/10 17:15:42.640: Setting system variable '@PROMPT' to 'C:\Program Files\TeleFlow\Languages\English' <br>2006/05/10 17:15:42.640: Setting global variable '@VOLUME' to '0' <br>2006/05/10 17:15:42.640: Setting global variable '@TIMEOUT' to '3000' <br>2006/05/10 17:15:42.640: Setting system variable '@FAXQPTR' to '' <br>2006/05/10 17:15:42.640: Setting system variable '@PORT' to '1' <br>2006/05/10 17:15:42.640: Setting system variable '@CALL_LINE' to '' <br>2006/05/10 17:15:42.640: Setting system variable '@SPELLTONES' to '' <br>2006/05/10 17:15:42.640: Setting system variable '@RECORD_RESULT' to '' <br>2006/05/10 17:15:42.640: Setting global variable '@SYS_DATA' to '' <br>2006/05/10 17:15:42.640: Setting system variable '@CHAR_SOH' to '' <br>2006/05/10 17:15:42.640: Setting system variable '@CHAR_STX' to '' <br>2006/05/10 17:15:42.640: Setting system variable '@CHAR_ETX' to '' <br>2006/05/10 17:15:42.640: Setting system variable '@CHAR_EOT' to '' <br>2006/05/10 17:15:42.640: Setting system variable '@CHAR_ENQ' to '' <br>2006/05/10 17:15:42.640: Setting system variable '@CHAR_ACK' to '' <br>2006/05/10 17:15:42.640: Setting system variable '@CHAR_BEL' to '' <br>2006/05/10 17:15:42.640: Setting system variable '@CHAR_BS' to '' <br>2006/05/10 17:15:42.640: Setting system variable '@CHAR_TAB' to ' ' <br>2006/05/10 17:15:42.656: Setting system variable '@TAB' to ' ' <br>2006/05/10 17:15:42.656: Setting system variable '@CHAR_LF' to ' <br> ' <br>2006/05/10 17:15:42.656: Setting system variable '@LINEFEED' to ' <br> ' <br>2006/05/10 17:15:42.656: Setting system variable '@CHAR_VT' to ' ' <br>2006/05/10 17:15:42.656: Setting system variable '@CHAR_FF' to ' ' <br>2006/05/10 17:15:42.656: Setting system variable '@FORMFEED' to ' ' <br>2006/05/10 17:15:42.656: Setting system variable '@CHAR_CR' to '' <br>2006/05/10 17:15:42.656: Setting system variable '@CHAR_SO' to '' <br>2006/05/10 17:15:42.656: Setting system variable '@CHAR_SI' to '' <br>2006/05/10 17:15:42.656: Setting system variable '@CHAR_DLE' to '' <br>2006/05/10 17:15:42.656: Setting system variable '@CHAR_DC1' to '' <br>2006/05/10 17:15:42.656: Setting system variable '@CHAR_DC2' to '' <br>2006/05/10 17:15:42.656: Setting system variable '@CHAR_DC3' to '' <br>2006/05/10 17:15:42.656: Setting system variable '@CHAR_DC4' to '' <br>2006/05/10 17:15:42.656: Setting system variable '@CHAR_NAK' to '' <br>2006/05/10 17:15:42.656: Setting system variable '@CHAR_SYN' to '' <br>2006/05/10 17:15:42.656: Setting system variable '@CHAR_ETB' to '' <br>2006/05/10 17:15:42.656: Setting system variable '@CHAR_CAN' to '' <br>2006/05/10 17:15:42.656: Setting system variable '@CHAR_EM' to '' <br>2006/05/10 17:15:42.656: Setting system variable '@CHAR_SUB' to '' <br>2006/05/10 17:15:42.656: Setting system variable '@CHAR_ESC' to '' <br>2006/05/10 17:15:42.656: Setting system variable '@CHAR_FS' to '' <br>2006/05/10 17:15:42.656: Setting system variable '@CHAR_GS' to '' <br>2006/05/10 17:15:42.656: Setting system variable '@CHAR_RS' to '' <br>2006/05/10 17:15:42.656: Setting system variable '@CHAR_US' to '' <br>2006/05/10 17:15:42.671: Setting system variable '@SPACE' to ' ' <br>2006/05/10 17:15:42.671: Setting system variable '@CHAR_DEL' to '' <br>2006/05/10 17:15:42.671: Setting system variable '@HANGUP' to '' <br>2006/05/10 17:15:42.671: Setting system variable '@FATAL' to '' <br>2006/05/10 17:15:42.671: Setting system variable '@CALL_SEIZED' to '' <br>2006/05/10 17:15:42.671: Setting system variable '@CALL_START' to '' <br>2006/05/10 17:15:42.671: Setting system variable '@CALL_END' to '' <br>2006/05/10 17:15:42.671: Setting system variable '@CALL_ELAPSE' to '' <br>2006/05/10 17:15:42.671: Setting system variable '@WEEKDAY' to '' <br>2006/05/10 17:15:42.671: Setting system variable '@DATE' to '' <br>2006/05/10 17:15:42.671: Setting system variable '@TIME' to '' <br>2006/05/10 17:15:42.671: Setting system variable '@UNIX_TIME' to '' <br>2006/05/10 17:15:42.671: Setting system variable '@HOOK_STATUS' to '' <br>2006/05/10 17:15:42.671: Setting system variable '@APPID' to '1001' <br>2006/05/10 17:15:42.671: Setting system variable '@CALLOUT_RESULT' to '' <br>2006/05/10 17:15:42.671: Setting system variable '@CALLOUT_REASON' to '' <br>2006/05/10 17:15:42.671: Setting system variable '@TRUNK_TYPE' to '' <br>2006/05/10 17:15:42.671: Setting system variable '@SYS_CALLREF' to '' <br>2006/05/10 17:15:42.671: Initializing... <br> <br>2006/05/10 17:15:42.671: <br> Initialization done <br> <br>2006/05/10 17:15:42.671: ==>TP_Bienvenida <br>2006/05/10 17:15:42.671: [1] START <br>2006/05/10 17:15:42.671: [3] Reload On <br>2006/05/10 17:15:42.671: [65] Global Event <br>2006/05/10 17:15:42.687: Setting system variable '@HANGUP' to 'LABFINISH0' <br>2006/05/10 17:15:42.687: [49] Run Flowchart <br>2006/05/10 17:15:42.687: Flowchart: 'Defaults' <br>2006/05/10 17:15:42.687: TP_Bienvenida==>Defaults <br>2006/05/10 17:15:42.687: [1] START <br>2006/05/10 17:15:42.687: [122] Set Language <br>2006/05/10 17:15:42.687: Loading language 'C:\Program Files\TeleFlow\Lang_Spanish.dll' <br>2006/05/10 17:15:42.687: Setting system variable '@PROMPT' to 'C:\Program Files\TeleFlow\Languages\Spanish' <br>2006/05/10 17:15:42.687: [86] Set Global Variable <br>2006/05/10 17:15:42.703: Setting global variable '@MENULOOP' to '3' <br>2006/05/10 17:15:42.703: [96] Set Global Variable <br>2006/05/10 17:15:42.703: Setting global variable '@DBLOOP' to '4' <br>2006/05/10 17:15:42.703: [100] Set Global Variable <br>2006/05/10 17:15:42.703: Setting global variable '@PLAY_VOLUME' to '0' <br>2006/05/10 17:15:42.703: [102] Set Global Variable <br>2006/05/10 17:15:42.703: Setting global variable '@
Author:  saugortgarcia [ Wed May 10, 2006 2:26 pm ]
Post subject: 
2006/05/10 17:15:42.703: Setting global variable '@REC_VOLUME' to '0' <br>2006/05/10 17:15:42.703: [107] Set Global Variable <br>2006/05/10 17:15:42.703: Setting global variable '@SYSLOC' to 'C:\VAPP\RepMan' <br>2006/05/10 17:15:42.703: [104] Connect Point <br>2006/05/10 17:15:42.703: [105] Connect Point <br>2006/05/10 17:15:42.703: [132] Set Global Variable <br>2006/05/10 17:15:42.703: Setting global variable '@RINGCOUNT' to '5' <br>2006/05/10 17:15:42.703: [88] Set Global Variable <br>2006/05/10 17:15:42.718: Setting global variable '@COUNTER' to '0' <br>2006/05/10 17:15:42.718: [98] Set Global Variable <br>2006/05/10 17:15:42.718: Setting global variable '@DB_COUNTER' to '0' <br>2006/05/10 17:15:42.718: [109] Set Global Variable <br>2006/05/10 17:15:42.718: Setting global variable '@VOLUME' to '0' <br>2006/05/10 17:15:42.718: [111] Compare <br>2006/05/10 17:15:42.718: @TRUNK_TYPE = ANALOG? <br>2006/05/10 17:15:42.718: (string):SIMULATED = (string):ANALOG? <br>2006/05/10 17:15:42.718: FALSE <br>2006/05/10 17:15:42.718: [116] Set Global Variable <br>2006/05/10 17:15:42.718: Setting global variable '@PICKUP_RINGCOUNT' to '0' <br>2006/05/10 17:15:42.718: [118] Set Global Variable <br>2006/05/10 17:15:42.718: Setting global variable '@CONNECTION_DELAY' to '500' <br>2006/05/10 17:15:42.718: [129] Set Global Variable <br>2006/05/10 17:15:42.718: Setting global variable '@HANG_WAIT' to '1000' <br>2006/05/10 17:15:42.718: [131] Connect Point <br>2006/05/10 17:15:42.718: [2] FINISH <br>2006/05/10 17:15:42.734: TP_Bienvenida<==Defaults <br>2006/05/10 17:15:42.734: [19] Wait for Call <br>2006/05/10 17:15:44.234: Wait for 2 rings and then pickup <br>2006/05/10 17:15:50.828: Setting global variable '@LLAMANTE_ANI' to '' <br>2006/05/10 17:15:50.828: Setting global variable '@LLAMANTE_DNIS' to '' <br>2006/05/10 17:15:50.828: Connection delay: 500 ms <br>2006/05/10 17:15:51.328: [50] Set Global Variable <br>2006/05/10 17:15:51.328: Setting global variable '@COUNTER' to '3' <br>2006/05/10 17:15:51.328: [17] Set Global Variable <br>2006/05/10 17:15:51.328: Setting global variable '@LLAMADA_INGRESO' to '2006/05/10 17:15:51' <br>2006/05/10 17:15:51.328: [69] Run Flowchart <br>2006/05/10 17:15:51.328: Flowchart: 'TP_DBLogger' <br>2006/05/10 17:15:51.328: Setting local variable '@T_OP' to 'NEW' <br>2006/05/10 17:15:51.328: TP_Bienvenida==>TP_DBLogger <br>2006/05/10 17:15:51.343: [1] START <br>2006/05/10 17:15:51.343: [3] DB Connect <br>2006/05/10 17:15:51.343: ConnectString: DSN=VAppRepDB;UID=ivradmin;PWD=ivradmin <br>2006/05/10 17:15:51.359: SQL Error State: 01000 <br> Native Error Code: 1645 <br> ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'IVRCDR'. <br>2006/05/10 17:15:51.359: SQL Error State: 01000 <br> Native Error Code: 1647 <br> ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english. <br>2006/05/10 17:15:51.375: SQL Error State: HY092 <br> Native Error Code: 0 <br> ODBC Error: [Microsoft][ODBC SQL Server Driver]Invalid attribute/option identifier <br>2006/05/10 17:15:51.375: [9] Case <br>2006/05/10 17:15:51.375: Case argument '@T_OP' evaluates to 'NEW' <br>2006/05/10 17:15:51.375: Case 1 value 'NEW' evaluates to 'NEW' <br>2006/05/10 17:15:51.375: [25] Set Global Variable <br>2006/05/10 17:15:51.375: Setting global variable '@T' to '@T' <br>2006/05/10 17:15:51.375: [6] SQL Statement <br>2006/05/10 17:15:51.375: Warning time threshold not specified, using default of 2000 ms <br>2006/05/10 17:15:51.375: <----- BEGIN -----> <br> declare @T int <br> exec sp_addnewcall '', '', '2006/05/10 17:15:51', 1, 'I', 'CESTATICKET_V0', @T output <br> select @T <br> <br> <br> <br> <----- END -----> <br>2006/05/10 17:15:51.390: Elapsed Time: 0.015 <br>2006/05/10 17:15:51.390: [8] SQL End <br>2006/05/10 17:15:51.390: [5] DB Disconnect <br>2006/05/10 17:15:51.390: [2] FINISH <br>2006/05/10 17:15:51.406: TP_Bienvenida<==TP_DBLogger <br>2006/05/10 17:15:51.406: [25] Play <br>2006/05/10 17:15:51.406: Script code 'Vox\Eng\Scripts\msj000.Wav' evaluates to 'Vox\Eng\Scripts\msj000.Wav' <br>2006/05/10 17:15:51.406: Playing 'C:\VAPP\RepMan\Vox\Eng\Scripts\msj000.Wav' <br>2006/05/10 17:15:55.187: [27] Play <br>2006/05/10 17:15:55.187: Script code 'Vox\Eng\Scripts\msj001.Wav' evaluates to 'Vox\Eng\Scripts\msj001.Wav' <br>2006/05/10 17:15:55.187: Playing 'C:\VAPP\RepMan\Vox\Eng\Scripts\msj001.Wav' <br>2006/05/10 17:16:04.859: Caller hung up <br>2006/05/10 17:16:04.906: HANGUP <br>2006/05/10 17:16:04.906: Attempting to jump to Hangup Global Event label: 'LABFINISH0' <br>2006/05/10 17:16:04.906: [66] Label <br>2006/05/10 17:16:04.906: Label: LABFINISH0 <br>2006/05/10 17:16:04.906: [67] Wait <br>2006/05/10 17:16:04.921: Waiting 1500 milliseconds <br>2006/05/10 17:16:06.421: [21] Hang Up <br>2006/05/10 17:16:06.421: [63] Set Global Variable <br>2006/05/10 17:16:06.421: Setting global variable '@LLAMADA_TERMINO' to '2006/05/10 17:16:06' <br>2006/05/10 17:16:06.421: [7] Go to Label <br>2006/05/10 17:16:06.437: Label: 'LABFINISH1' <br>2006/05/10 17:16:06.437: [6] Label <br>2006/05/10 17:16:06.437: Label: LABFINISH1 <br>2006/05/10 17:16:06.453: [2] FINISH <br>2006/05/10 17:16:06.453: End of application. <br>2006/05/10 17:16:08.625: XMLList destructor done <br> <br>Store procedure: <br>CREATE PROCEDURE [dbo].[sp_AddNewCall] @call_an VARCHAR(25), @call_dns VARCHAR(25), @call_begin VARCHAR(25), @call_port int, @call_typ char, @call_app VARCHAR(25), @call_dbid int output AS <br>INSERT INTO call_dump(call_ani,call_dnis,call_start,call_port,call_type,call_vapp) <br>VALUES(@call_an,@call_dns,CAST(@call_begin AS DATETIME),@call_port,@call_typ,@call_app) <br> <br>declare @Call_ID int <br>select @Call_ID = call_ref from call_dump <br>where call_ani = @call_an and call_dnis = @call_dns and call_start = CAST(@call_begin AS DATETIME) and call_port = @call_port and call_type = @call_typ and call_vapp = @call_app <br> <br>INSERT INTO call_dump_detail <br>VALUES( @Call_ID, 'MENU_PPL', @call_app, CAST(@call_begin AS DATETIME)) <br> <br>-- SELECT @Call_ID AS CALL_DBID <br>select @Call_dbid = call_ref from call_dump <br>where call_ani = @call_an and call_dnis = @call_dns and call_start = CAST(@call_begin AS DATETIME) and call_port = @call_port and call_type = @call_typ and call_vapp = @call_app <br> <br>return @call_dbid <br>GO
Author:  Chris [ Mon May 15, 2006 10:26 am ]
Post subject: 
We only use stored procedure we are provided by others, so I can't advise you on precisely what the problem is, however, here is a description of the typical problem people have getting results returned in TeleFlow, and what they do to get past it: <br> <br>Because of the way TeleFlow retrieves data, column names must be returned. Here is a cut down description from someone who created stored procedures that work from within TeleFlow, where they had this problem at first, and <br>subsequently fixed it: <br>" <br>Originally I had the final select statement as: <br> > SELECT @MessageType, @PIN <br> <br>This didn't work because there were no column names for what was returned. So I changed it to: <br>SELECT @MessageType MessageType, @PIN PIN where there were column names as MessageType and PIN. <br>" <br> <br>I suspect that this line <br> <br>select @Call_dbid = call_ref from call_dump <br> <br>Needs to have something like this: <br>"select @Call_dbid Call_dbid" to return it to TeleFlow.
Page 1 of 1 All times are UTC - 8 hours [ DST ]
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/