ODBC ERROR

[GilMerc]

HI,

I use Impromptu 7.1 and ODBC to connect to Oracle.
I have a big problem since 1 week when I pass a long parametre list I have an error from odbc. The error message is :

Erreur nº -239 :

DMS-E-GENERAL, Une erreur est survenue pendant l'opération appliquer les options à la requête.
DMS-F-BUGCHECK, Une erreur système interne est survenue pendant l'opération prepare request.
[Oracle][ODBC]Invalid column number <1>.


I saw in log file that Impromptu transform a if-then-else filter in decode(...) statement. I suppose that a tranformation will be wrong BUT IN SOME CASE THE STATEMENT IS OK AND THE REPORT IS COMPLETED CORRECTLY WITH A SAME LIST PARAMETRE.

Somebody can be help me?

Gilles.

 

[Chargrams]

Which version of Oracle are you using?

...Chargrams

 

[GilMerc]

Oracle's version is : 8.1.7

Gilles.