Devart Forums

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"));

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)

Code: Select all

create or replace VARCHAR_SQUARE  as table OF varchar_tbl

Code: Select all

create or replce VARCHAR_TBL as table of varchar2

Code: Select all

create or replace procedure conv_from_message_to_message2 (
  p_pl_sup in  message
 ,p_pl_sub out message2)
 is
 begin
 p_pl_sub := treat(p_pl_sup as message2);
 end;

Code: Select all

msg.ObjectPayload = obj;

Code: Select all

  oracleQueue.PayloadTypeName = "A_OBJTYPE";

  OracleQueueMessage  msg = oracleQueue.Dequeue();

  oracleObject Try = new OracleObject("B_OBJTYPE", oracleConnection);

  Try = (OracleObject)msg.ObjectPayload.Clone();

  string olala = Try[].ToString();