Oracle pipelined

CREATE OR REPLACE PACKAGE resp IS

  type rowResp is record(

    supplierbillid sergey.sample.field1%TYPE

    ,altpayeridentifier sergey.sample.field2%TYPE

  );

  type tblResp is table of rowResp; 

  function GetResp(

     p_id sergey.sample.id%TYPE)

END;

create or replace package body resp is

  function GetResp(

     p_id sergey.sample.id%TYPE)

  is

  begin

    for curr in

    (

      select field1, field2

        from sergey.sample

        where id = p_id

    ) loop

    pipe row (curr);

    end loop;

  end GetResp;

end;

select * 

  from TABLE(sergey.resp.GetResp(10531343));