ArrayExecute insertion to varchar column with double value
ArrayExecute insertion to varchar column with double value
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?
-
Pinturiccio
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: ArrayExecute insertion to varchar column with double value
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.
As a temporary workaround, assign a string to the first element of the array that is assigned to the parameter.
-
Pinturiccio
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: ArrayExecute insertion to varchar column with double value
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: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: ArrayExecute insertion to varchar column with double value
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
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