domo Report post Posted 11/27/2003 11:30 AM Hello, I query an Oracle DB with SELECT to_char(id_przed), to_char(rodz_id), to_char(ocena_1), to_char(ocena_2), to_char(ocena_3), to_char(ocena_4), to_char(data) FROM VG_V_OCENY2 WHERE album='4942' and semestr=3 this is what I get after in log. 121833,05 6 [Zapytanie] DB Query 121833,05 6 ODBC mode used 121833,16 6 RVreplace start (strlen>100) 121833,16 6 About to execute Retrieve Operation [SELECT to_char(id_przed), to_char(rodz_id), to_char(ocena_1), to_char(ocena_2), to_char(ocena_3), to_char(ocena_4), to_char(data) FROM VG_V_OCENY2 WHERE album='4942' and semestr=3] 121833,57 6 [Zapytanie] row count=19 121833,57 6 ERROR 5.0.2000 RunModule:0:13:Type mismatch:VoiceGuide 121833,57 6 Hanging up call... [RunModule Error] Can you help me? VG: 5.0.2000 Oracle: 9i Best wishes Dominik Share this post Link to post
SupportTeam Report post Posted 11/27/2003 12:02 PM Looks like the Database Query module retrieved data from database OK (trace shows 19 records were returned by the SQL query), so the problem lies not with the Database query or Oracle, but what happens afterwards... Could I ask you to please uninstall your current v5.0 and install v5.1.3 instead and post the trace from the current version - if the problem still occurs. If the problem still does occur we can then try to reproduce it and resolve it. Share this post Link to post