VoiceGuide IVR Software Main Page
Jump to content

Oracle + Sql Query = Vg Error

Recommended Posts

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

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

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
×