SQL> ed
Wrote file afiedt.buf

  1  create or replace package p_stax is
  2     TYPE tt_emp IS TABLE OF emp%ROWTYPE;
  3     vp_emp tt_emp;
  4* end;
SQL> /

SQL> ed
Wrote file afiedt.buf

  1  create or replace package body p_stax is
  2  BEGIN
  3     SELECT * BULK COLLECT INTO vp_emp FROM emp;
  4* end;
SQL> /


SQL> create or replace function f_test
  2  return sys.ODCIVarchar2List
  3  IS
  4   v sys.ODCIVarchar2List :=sys.ODCIVarchar2List();
  5  begin
  6     v.Extend(p_stax.vp_emp.Count());
  7     FOR i IN p_stax.vp_emp.FIRST .. p_stax.vp_emp.LAST loop
  8       v(i):=p_stax.vp_emp(i).ename||' '||p_stax.vp_emp(i).job;
  9     end loop;
 10     return v;
 11  end;
 12  /

Function created.
SQL> select * from table(f_test);

COLUMN_VALUE
--------------------------------------
SMITH CLERK
ALLEN SALESMAN
WARD SALESMAN
JONES MANAGER
MARTIN SALESMAN
BLAKE MANAGER
CLARK MANAGER
SCOTT ANALYST
KING PRESIDENT
TURNER SALESMAN
ADAMS CLERK
JAMES CLERK
FORD ANALYST
MILLER CLERK

14 rows selected.