ExecuteArray and nullable int32 or nullable decimal values
Posted: Fri 24 Jun 2011 10:03
Hi devart team,
i have trouble with nullable int32 and nullable decimal parameters during ExecuteArray calls.
(I have not checked all other datatypes yet...)
The parameter has correct settings
param.IsNullable = true
and the values in the array also nullable types
I get an exception
InvalidCastException
{"Ungültige Umwandlung von \"System.Decimal\" in \"System.Nullable`1[[System.Decimal, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]\"."}
mscorlib.dll!System.Convert.DefaultToType(System.IConvertible value, System.Type targetType, System.IFormatProvider provider) + 0x4dc Bytes
mscorlib.dll!decimal.System.IConvertible.ToType(System.Type type, System.IFormatProvider provider) + 0x25 Bytes
mscorlib.dll!System.Convert.ChangeType(object value, System.Type conversionType, System.IFormatProvider provider) + 0x1fd Bytes
Devart.Data.Oracle.dll!Devart.Data.Oracle.OracleParameter.a(ref Devart.Data.Oracle.ay A_0 = {Devart.Data.Oracle.ay}, bool A_1 = true, bool A_2 = false, Devart.Data.Oracle.OracleCommand A_3 = {Devart.Data.Oracle.OracleCommand}, byte[] A_4 = {byte[871344]}, System.Collections.Hashtable A_5 = Count = 0, Devart.Data.Oracle.ah A_6 = {Devart.Data.Oracle.a1}) + 0x7b1 Bytes
Devart.Data.Oracle.dll!Devart.Data.Oracle.OracleCommand.a(Devart.Data.Oracle.OracleParameterCollection A_0 = {Devart.Data.Oracle.OracleParameterCollection}, Devart.Data.Oracle.ay[] A_1 = {Devart.Data.Oracle.ay[5]}, Devart.Data.Oracle.ch A_2 = {Devart.Data.Oracle.av}, Devart.Data.Oracle.ah A_3 = {Devart.Data.Oracle.a1}) + 0x130 Bytes
Devart.Data.Oracle.dll!Devart.Data.Oracle.OracleCommand.InternalExecute(System.Data.CommandBehavior behavior = Default, System.IDisposable disposable = {Devart.Data.Oracle.bj}, int startRecord = 0, int maxRecords = 0, bool nonQuery = true) + 0xb63 Bytes
Devart.Data.dll!Devart.Common.DbCommandBase.ExecuteDbDataReader(System.Data.CommandBehavior behavior = Default, bool nonQuery = true) + 0x153 Bytes
Devart.Data.Oracle.dll!Devart.Data.Oracle.OracleCommand.ExecuteNonQuery() + 0x4c Bytes
Devart.Data.Oracle.dll!Devart.Data.Oracle.OracleCommand.ExecuteArray(int iters = 12102) + 0xcc Bytes
> RLV!KVNo.Komponenten.fachlich.DezentraleAbrechnung.RLV.EntityModel.RlvModelExtensions.
RlvInsertByCommand.DoExecute() Zeile 902 + 0xd5 Bytes C#
Any help or bugfix??
I am using the last release build version:
6.30.160.0
Roman
i have trouble with nullable int32 and nullable decimal parameters during ExecuteArray calls.
(I have not checked all other datatypes yet...)
The parameter has correct settings
param.IsNullable = true
and the values in the array also nullable types
I get an exception
InvalidCastException
{"Ungültige Umwandlung von \"System.Decimal\" in \"System.Nullable`1[[System.Decimal, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]\"."}
mscorlib.dll!System.Convert.DefaultToType(System.IConvertible value, System.Type targetType, System.IFormatProvider provider) + 0x4dc Bytes
mscorlib.dll!decimal.System.IConvertible.ToType(System.Type type, System.IFormatProvider provider) + 0x25 Bytes
mscorlib.dll!System.Convert.ChangeType(object value, System.Type conversionType, System.IFormatProvider provider) + 0x1fd Bytes
Devart.Data.Oracle.dll!Devart.Data.Oracle.OracleParameter.a(ref Devart.Data.Oracle.ay A_0 = {Devart.Data.Oracle.ay}, bool A_1 = true, bool A_2 = false, Devart.Data.Oracle.OracleCommand A_3 = {Devart.Data.Oracle.OracleCommand}, byte[] A_4 = {byte[871344]}, System.Collections.Hashtable A_5 = Count = 0, Devart.Data.Oracle.ah A_6 = {Devart.Data.Oracle.a1}) + 0x7b1 Bytes
Devart.Data.Oracle.dll!Devart.Data.Oracle.OracleCommand.a(Devart.Data.Oracle.OracleParameterCollection A_0 = {Devart.Data.Oracle.OracleParameterCollection}, Devart.Data.Oracle.ay[] A_1 = {Devart.Data.Oracle.ay[5]}, Devart.Data.Oracle.ch A_2 = {Devart.Data.Oracle.av}, Devart.Data.Oracle.ah A_3 = {Devart.Data.Oracle.a1}) + 0x130 Bytes
Devart.Data.Oracle.dll!Devart.Data.Oracle.OracleCommand.InternalExecute(System.Data.CommandBehavior behavior = Default, System.IDisposable disposable = {Devart.Data.Oracle.bj}, int startRecord = 0, int maxRecords = 0, bool nonQuery = true) + 0xb63 Bytes
Devart.Data.dll!Devart.Common.DbCommandBase.ExecuteDbDataReader(System.Data.CommandBehavior behavior = Default, bool nonQuery = true) + 0x153 Bytes
Devart.Data.Oracle.dll!Devart.Data.Oracle.OracleCommand.ExecuteNonQuery() + 0x4c Bytes
Devart.Data.Oracle.dll!Devart.Data.Oracle.OracleCommand.ExecuteArray(int iters = 12102) + 0xcc Bytes
> RLV!KVNo.Komponenten.fachlich.DezentraleAbrechnung.RLV.EntityModel.RlvModelExtensions.
RlvInsertByCommand.DoExecute() Zeile 902 + 0xd5 Bytes C#
Any help or bugfix??
I am using the last release build version:
6.30.160.0
Roman