SQL> create or replace type t_emp as object (
   2      empno number ( 9 )
   3    , ename varchar2( 10 )
   4    , member function get_ename return varchar2
   5   )
   6   /
Type created.
SQL> create or replace type body t_emp as
   2    member function get_ename return varchar2 is begin return ename; end;
   3   end;
   4   /
Type body created.
SQL> create or replace type tbl_emp as table of t_emp
   2   /
Type created.
SQL> create table test (
   2      test_id number( 9 )
   3    , emp tbl_emp
   4    , constraint pk_test primary key (test_id)
   5   )
   6   nested table emp store as test_emp
   7   /
Table created.
SQL> declare vt tbl_emp := tbl_emp();
   2   begin
   3    for i in (select empno, ename from scott.emp where deptno =  20 ) loop
   4      vt.extend;
   5      vt(vt.count) := t_emp(i.empno, i.ename);
   6    end loop;
   7    delete test;
   8    insert into test(test_id, emp) values ( 1 , vt);
   9    commit;
  10   end;
  11   /
PL/SQL procedure successfully completed.
SQL> select t.test_id,(cursor(select e.get_ename() ename from TABLE(t.emp) e)) ename from test t
   2   /

   TEST_ID ENAME
 ---------- --------------------
 
          1  CURSOR STATEMENT :  2 

CURSOR STATEMENT :  2 

ENAME
 --------------------------------------------------------------------------------
 
SMITH
JONES
SCOTT
ADAMS
FORD