//using Devart.Data.Oracle;
using System;
using System.Collections.Generic;
. . .
namespace ns_ГИС {
  public partial class uc_ИнспекцииВД : UserControl, I_Плитка {
    public byte nMax = 20;
    public row_Entity xrow, yrow;

    long pk_Long;
    ObservableCollection<row_Entity> oc_Entity = new ObservableCollection<row_Entity>();  //-- Показываем в DataGrid 
    List<row_Entity> lst_Entity; //-- Временное хранение выборки
    //OracleParameter[] asp;
. . .
      //-- Готовим параметр запроса
      //asp = new OracleParameter[4]{null, new OracleParameter("x_nazvanie", xstr),
      //  new OracleParameter("x_dt_begin", (DateTime)dpr_Начало.SelectedDate), new OracleParameter("x_dt_end", (DateTime)dpr_Конец.SelectedDate)
      //};
      Object[][] psp = new object[3][];
      psp[0] = new object[2] { "x_nazvanie", xstr };
      psp[1] = new object[2] { "x_dt_begin", (DateTime)dpr_Начало.SelectedDate };
      psp[2] = new object[2] { "x_dt_end", (DateTime)dpr_Конец.SelectedDate };
      при.tmrStart(); await Task.Run(() => wsp.Entity_SP("NCUYAO_GIS.VD_Inspek_Sel", wsp.sp_Sel, psp, RowToEntity)); при.tmrStop();
. . .
===============================================
using Devart.Data.Oracle;
using System;
using System.Data;

namespace ns_ГИС {
  public delegate void dlg_sp(dlg_RowToEntity RowToEntity);
  public delegate void dlg_RowToEntity(IDataRecord reader);
. . .
    //-- Выполнение хранимой процедуры
    public static void Entity_SP(string spname, dlg_sp sp, object[][] psp, dlg_RowToEntity RowToEntity) {
      nRow = 0;  //-- Число строк в выборке
      reader = null; wspErr = null;
      int n = (psp==null)? 0: psp.Length;
      OracleParameter[] asp = new OracleParameter[n+1];
      asp[0]= new OracleParameter("cur_viborka", OracleDbType.Cursor, ParameterDirection.Output);
      try {
        for (int i=0;i<n;i++) {
          switch (psp[i].Length) {
            case 2: asp[i+1] = new OracleParameter((string)psp[i][0], psp[i][1]); break;
            case 3: asp[i+1] = new OracleParameter((string)psp[i][0], OracleDbType.Raw, (int)psp[i][1], psp[i][2], ParameterDirection.Input); break;
          }
        }
        using (OracleConnection connection = new OracleConnection(гп.str_Соединение)) {
          connection.Open();
          OracleCommand command = new OracleCommand("", connection);
          command.Parameters.Clear();
          command.Parameters.AddRange(asp);
          command.CommandText = spname;
          command.CommandType = CommandType.StoredProcedure;

          //-- Формируем коллекцию из выборки
          using (reader = (OracleDataReader)command.ExecuteReader()) { sp(RowToEntity); }
        }
      }
      catch (Exception ex){ wspErr = ex.Message; }
    }
. . .