CREATE OR REPLACE
TYPE NUMBERS as table of number

declare
  ds NUMBERS := NUMBERS();
begin
  ds.extend();
  ds(ds.count) := 100;
  ds.extend();  
  ds(ds.count) := 116;
  for cur in (select * from all_objects t, table(ds) c
                WHERE t.object_id = c.column_value) loop
    dbms_output.put_line ('cur '||cur.object_id||' cur name '||cur.object_name);                
  end loop;                
end; 

            cmd.Parameters.Add("DS", Oracle.DataAccess.Client.OracleDbType.Array, System.Data.ParameterDirection.Input);
            cmd.Parameters["DS"].UdtTypeName = "NUMBERS";

            private List <int> arrayIN = new List <int>();
            arrayIN.Add (100);
            arrayIN.Add (116);

            cmd.Parameters["DS"].Value = arrayIN;
                using (Oracle.DataAccess.Client.OracleDataAdapter da = new Oracle.DataAccess.Client.OracleDataAdapter())
                {
                    da.SelectCommand = cmd;
                    cmd.CommandText = baseQueryIN;
                    da.Fill(dt);
                }