I have a problem executing an ExecuteArray command on a table with a field of type LONGRAW
The following works fine
Code: Select all
string sql = "Insert into FL_KATEGORIENBILDER values (:1, :2)";
// write single line
long param1 = 4;
byte[] param2 = new byte[3] { 100, 101, 102 };
List parameter = new List();
parameter.Add(new OracleParameter("1", OracleDbType.Number, param1, ParameterDirection.Input));
parameter.Add(new OracleParameter("2", OracleDbType.LongRaw, param2, ParameterDirection.Input));
OracleCommand command = new OracleCommand(sql);
command.Parameters.Add(parameter);
command.ExecuteNonQuery();
Code: Select all
// write array with two lines
long[] param3 = new long[2] { 5, 6 };
byte[][] param4 = new byte[2][] { new byte[3] { 100, 101, 102 }, new byte[3] { 100, 101, 102 } };
parameter = new List();
parameter.Add(new OracleParameter("1", OracleDbType.Number, param3, ParameterDirection.Input));
parameter.Add(new OracleParameter("2", OracleDbType.LongRaw, param4, ParameterDirection.Input));
command = new OracleCommand(sql);
command.Parameters.Add(parameter);
command.ExecuteArray(2);
Eine Ausnahme (erste Chance) des Typs "System.InvalidCastException" ist in Devart.Data.dll aufgetreten.
17.04.2012 14:49:52::Info::--------------------------------------------------
17.04.2012 14:49:52::Error::Das Objekt des Typs "Devart.Data.Oracle.cj[]" kann nicht in Typ "Devart.Data.Oracle.cj" umgewandelt werden.
17.04.2012 14:49:52::Error:: bei Devart.Data.Oracle.OracleParameter.a(bb& A_0, Boolean A_1, OracleConnection A_2, Byte[] A_3, Hashtable A_4, an A_5, Boolean& A_6, Int32 A_7)
bei Devart.Data.Oracle.OracleCommand.a(al A_0, Int32 A_1, OracleParameterCollection A_2, an A_3, Boolean& A_4)
bei Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
bei Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
bei Devart.Data.Oracle.OracleCommand.ExecuteNonQuery()
bei Devart.Data.Oracle.OracleCommand.ExecuteArray(Int32 iters)
Can you give me any hint what's going wrong?
Regards
Rolf
Version: Devart dotConnect for Oracle 6.80.332.0