odbc driver problem ! urgent !

[Guest_imported]

Hi,

I have an application using Oracle odbc driver 8.0.4.0.0
the application runs fine but when i upgrade ORACLE and use the odbc driver 8.0.6.0.0, it gives an error message.
The application uses ORACLE as a backend. In one of the tables a field is varchar2(1800) for this the error message comes
"bind parameter value for '?' is too big(1337)"
when the field is made less than 1000 ie 999 it works well.
Please suggest as soon as possible.

 

[foxdev]

Does your application give you the ability to "trim" the value that is used as the bind parameter? This may not be relevant to your situation, but if there are hundreds of trailing blanks in the value that is being passed through ODBC, that may be one of the problems.

Robert Bradley

http://www.foxdev.com/

 

[Guest_imported]

The application actually involves a certain data file to be imported. One of the fields contains data of 1337 characters the same has been defined as a varchar2(1800). Next when the datafile is modified and tried to import when the no of characters become less than a 1000 the file gets imported. This problem does not occur when odbc driver version 8.0.4.0.0 is used, it occurs when 8.0.6.0.0 is used, why is this so ?Aren't the drivers backward compatible?