passing array of nullable to storedprocedure
Posted: Wed 26 Jan 2011 15:38
Code: Select all
CREATE OR REPLACE TYPE "NUMBER_TBL" table of number;
Code: Select all
StoredProcedure.Parameters.Add(new Devart.Data.Oracle.OracleParameter("array", Devart.Data.Oracle.OracleDbType.Table, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "", System.Data.DataRowVersion.Current, null, 0, "NUMBER_TBL"));
I suppose :
Code: Select all
StoredProcedure.Parameter["array"].Value = new double?[];
Code: Select all
StoredProcedure.ExecuteNonQuery();
Code: Select all
Can not convert.
Stack trace:
в Devart.Data.Oracle.NativeOracleObjectBase.a(Object A_0, OracleAttribute A_1, IntPtr A_2)
в Devart.Data.Oracle.NativeOracleArray.SetElementValue(Object value, Int32 i)
в Devart.Data.Oracle.NativeOracleArray.a(Object A_0)
в Devart.Data.Oracle.NativeOracleArray.set_Value(Array value)
в Devart.Data.Oracle.OracleParameter.a(OracleDbType A_0, Object A_1, Object A_2, Byte[] A_3, Hashtable A_4, Int32 A_5, Int32 A_6, Int32 A_7, Int32 A_8, Int32 A_9, Boolean A_10, OracleConnection A_11, ParameterDirection A_12, String A_13, a5 A_14, Boolean& A_15)