create or replace package pkg_1 is

  type str_msrs is record(
    T_HAR  INTEGER, --нужный оракловый тип поля
    T_NOMENK varchar2(128), -- нужный оракловый тип поля
    T_SUM   number(38, 15); -- нужная размерность
  type list_msrs is table of str_msrs;

  function get_data_msrs(dt date) return list_msrs
    pipelined;

end pkg_1;

create or replace package body pkg_1 is

  function get_data_msrs(dt date) return list_msrs
    pipelined is
    cur_msrs INTEGER;
    rowcur INTEGER;
    rec_i  str_msrs;
  begin
  
    cur_msrs := DBMS_HS_PASSTHROUGH.OPEN_CURSOR@MSQL2;
    DBMS_HS_PASSTHROUGH.PARSE@fb_rdu_prom(cur_msrs,                                          
    'SELECT h1.HAR, n1.NOMENK, Sum(z1.ZER) as sum  FROM  T_OPER o2 ' ||
    ' join T_SMEN s2 on o2.SMEN = s2.SMEN_KOD' ||
    ' join T_SOTRUD on ss2 on o2.BRIG = ss2.SOTRUD' ||
    ' join T_PODR p2 on o2.PODR = p2.PODR' ||
    ' join T_ANALIZ o1 on o1.ID=o2.ID' ||
    ' join T_NOMENKLAT n1 on o1.NOMEN= n1.NOMEN' ||
    ' join T_HAR_ANALIZ h1 on h1.ANALIZ = o1.ANALIZ' ||
    ' join T_ZER@MSQL2 z1 on h1.ZER = z1.ZER' ||
    ' WHERE o2.DATA = convert(datetime, ' || to_char(dt,'yyyymmdd') || ',112)'||
    ' Group by h1.HAR, n1.NOMENK');
    loop
      ROWCUR := DBMS_HS_PASSTHROUGH.FETCH_ROW@MSQL2(cur_msrs);
      EXIT WHEN ROWCUR = 0;
      DBMS_HS_PASSTHROUGH.GET_VALUE@MSQL2(cur_msrs,
                                                1,
                                                rec_i.T_HAR);
      DBMS_HS_PASSTHROUGH.GET_VALUE@MSQL2(cur_msrs,
                                                2,
                                                rec_i.T_NOMENK);
                                                                                      
      DBMS_HS_PASSTHROUGH.GET_VALUE@MSQL2(cur_msrs,
                                                3,
                                                rec_i.T_SUM);      
    
      pipe row(rec_i);
    end loop;   
  end;

end pkg_1;

select * from table(pkg_1.get_data_msrs(to_date('20180517','yyyymmdd')))