ArrayExecute insertion to varchar column with double value

ArrayExecute insertion to varchar column with double value

Postby kiki » Fri 15 Aug 2014 23:43

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?
kiki
 
Posts: 7
Joined: Wed 23 Mar 2011 21:05

Re: ArrayExecute insertion to varchar column with double value

Postby Pinturiccio » Mon 18 Aug 2014 13:27

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.
Pinturiccio
Devart Team
 
Posts: 1978
Joined: Wed 02 Nov 2011 09:44

Re: ArrayExecute insertion to varchar column with double value

Postby Pinturiccio » Wed 03 Sep 2014 12:05

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.
Pinturiccio
Devart Team
 
Posts: 1978
Joined: Wed 02 Nov 2011 09:44

Re: ArrayExecute insertion to varchar column with double value

Postby Pinturiccio » Thu 04 Sep 2014 14:24

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
Pinturiccio
Devart Team
 
Posts: 1978
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for Oracle