-- my_data is a function that returns pipelined function

FUNCTION  my_data(rec IN OUT emp.employees%ROWTYPE
                    )
                     RETURN out_rows PIPELINED IS

   

BEGIN

  ---- logic to populate


            PIPE ROW (record_type);

     
   
   RETURN;
EXCEPTION
   WHEN OTHERS THEN
     
null
END my_data;

 
-- Below function should call the above one. 

 
FUNCTION  function_2(rec  IN OUT emp.employees%ROWTYPE
                          ) RETURN out_rows PIPELINED
IS
  
   final_rows_v         out_rows ;

BEGIN

  select res.* BULK COLLECT INTO final_rows_v 
  FROM TABLE(my_data(rec)) res;
  
  FOR i in 1..final_rows_v .COUNT LOOP
  
   PIPE ROW(final_rows_v (i));
  END LOOP;
return;
  

END function_2;

 
I am getting

PLS-00382: expression is of wrong type

PLS-00306: wrong number or types of arguments in call to my_data

EXCEPTION
   WHEN OTHERS THEN
     
null;

SCOTT@orcl > desc NumList
 NumList TABLE OF NUMBER

SCOTT@orcl > create or replace
  2  function f1(p_deptno in number)
  3  return NumList
  4  pipelined
  5  is
  6  begin
  7      for v_rec in (select sal from emp where deptno = p_deptno) loop
  8        pipe row(v_rec.sal);
  9      end loop;
 10  end;
 11  /

Function created.

SCOTT@orcl > select * from table(f1(10));

COLUMN_VALUE
------------
        2450
        5000
        1300

SCOTT@orcl > create or replace
  2  function f1(p_deptno in out number)
  3  return NumList
  4  pipelined
  5  is
  6  begin
  7      for v_rec in (select sal from emp where deptno = p_deptno) loop
  8        pipe row(v_rec.sal);
  9      end loop;
 10  end;
 11  /

Function created.

SCOTT@orcl > select * from table(f1(10));
select * from table(f1(10))
                    *
ERROR at line 1:
ORA-06572: Function F1 has out arguments


SCOTT@orcl >