Page 1 of 1

ArrayExecute insertion to varchar column with double value

Posted: Fri 15 Aug 2014 23:43
by kiki
When I trying to do a executeArray insertion with single column varchar(50), the parameter value list contains both double and string. I will got “Input string was not in a correct format.” Exception. Why cant you convert double to string?

Re: ArrayExecute insertion to varchar column with double value

Posted: Mon 18 Aug 2014 13:27
by Pinturiccio
We have reproduced the issue. We will investigate it and post here about the results as soon as possible.

As a temporary workaround, assign a string to the first element of the array that is assigned to the parameter.

Re: ArrayExecute insertion to varchar column with double value

Posted: Wed 03 Sep 2014 12:05
by Pinturiccio
We have fixed the bug with ignoring of the assigned DbType/OracleDbType when using array binding. We will post here when the corresponding build of dotConnect for Oracle is available for download.

Re: ArrayExecute insertion to varchar column with double value

Posted: Thu 04 Sep 2014 14:24
by Pinturiccio
New build of dotConnect for Oracle 8.4.239 is available for download!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=30327