create or replace package test is

   -- Public type declarations
  TYPE is_Table IS TABLE OF Table1%ROWTYPE INDEX BY BINARY_INTEGER;
  
  procedure p(t in out is_Table);

end test;


create or replace package body test is
 
   procedure p(t in out is_Table) is
   begin
  
      for x in (select * from table1) loop
         t(x.id):=x;
      end loop;
   end p;

end test;

OleDbCommand cmd = new OleDbCommand("test.p");
cmd.CommandType = CommandType.StoredProcedure;
        
cmd.Parameters.Add("@t", OleDbType.Какой-то_тип_наверное_не_знаю_какой);
cmd.Parameters["@t"].Direction = ParameterDirection.ReturnValue;
        
dm.ExecuteNonQuery(cmd);
        
object o = cmd.Parameters["@t"].Value;