Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TYPE t_tvf_row IS OBJECT(
  i NUMBER,
  n VARCHAR2(30)
);
CREATE TYPE t_tvf_tbl IS TABLE OF t_tvf_row;
CREATE OR REPLACE PACKAGE pkg_test_oracle_tvfs IS
  FUNCTION fn_get_tvf(
    p_max_num_rows INTEGER
  ) RETURN t_tvf_tbl;
END pkg_test_oracle_tvfs;
/
CREATE OR REPLACE PACKAGE BODY pkg_test_oracle_tvfs IS
  FUNCTION fn_get_tvf(
    p_max_num_rows INTEGER
  ) RETURN t_tvf_tbl
  IS
    v_tvf_tbl t_tvf_tbl;
  BEGIN
    SELECT t_tvf_row(
             rownum,
             object_name
           )
    BULK COLLECT INTO v_tvf_tbl
    FROM   (
      SELECT object_name
      FROM   user_objects
      ORDER BY object_name
    )
    WHERE rownum <= p_max_num_rows;

    RETURN v_tvf_tbl;
  END;
END pkg_test_oracle_tvfs;
/
SELECT * FROM USER_ERRORS;
SELECT * FROM pkg_test_oracle_tvfs.fn_get_tvf(5);


I
N


1
PKG_TEST_ORACLE_TVFS

2
PKG_TEST_ORACLE_TVFS

3
T_TVF_ROW

4
T_TVF_TBL

I	N
1	PKG_TEST_ORACLE_TVFS
2	PKG_TEST_ORACLE_TVFS
3	T_TVF_ROW
4	T_TVF_TBL