declare
    r type_tr:=type_tr();
  begin
    select * bulk collect into r from table(func_getNames(1));
  end;

SCOTT@orcl_11g> CREATE OR REPLACE TYPE TYPE_R IS OBJECT(
  2  ID NUMBER,
  3  Name varchar2(40)
  4  );
  5  /

Type created.

SCOTT@orcl_11g> CREATE OR REPLACE TYPE TYPE_TR IS TABLE OF TYPE_R;
  2  /

Type created.

SCOTT@orcl_11g> CREATE OR REPLACE FUNCTION FUNC_GETNames
  2    (p_num IN NUMBER)
  3    RETURN type_tr PIPELINED
  4  AS
  5    v_rec type_tr := type_tr ();
  6  BEGIN
  7    SELECT type_r (empno, ename)
  8    BULK   COLLECT INTO v_rec
  9    FROM   emp
 10    WHERE  deptno = p_num;
 11    FOR i IN 1 .. v_rec.COUNT LOOP
 12  	 PIPE ROW (v_rec(i));
 13    END LOOP;
 14    RETURN;
 15  END FUNC_GETNames;
 16  /

Function created.

SCOTT@orcl_11g> SHOW ERRORS
No errors.
SCOTT@orcl_11g> SELECT * FROM TABLE (func_getNames (10))
  2  /

        ID NAME
---------- ----------------------------------------
      7782 CLARK
      7839 KING
      7934 MILLER

SCOTT@orcl_11g> declare
  2  	 r type_tr:=type_tr();
  3    begin
  4  	 select *
  5  	 bulk	collect into r
  6  	 from	table(func_getNames(10));
  7    end;
  8  /
    from   table(func_getNames(10));
    *
ERROR at line 6:
ORA-06550: line 6, column 5:
PL/SQL: ORA-00947: not enough values
ORA-06550: line 4, column 5:
PL/SQL: SQL Statement ignored

SCOTT@orcl_11g> declare
  2  	 r type_tr:=type_tr();
  3    begin
  4  	 select type_r (t.id, t.name) 
  5  	 bulk	collect into r
  6  	 from	table(func_getNames(10)) t;
  7  	 for i in 1 .. r.count loop
  8  	   dbms_output.put_line (r(i).id || ' ' || r(i).name);
  9  	 end loop;
 10    end;
 11  /
7782 CLARK
7839 KING
7934 MILLER

PL/SQL procedure successfully completed.

SCOTT@orcl_11g>

SQL> declare
  2   type r is record (
  3     ID NUMBER,
  4     Name varchar2(40)
  5   );
  6   type tr is table of r index by pls_integer;
  7   t tr;
  8  begin
  9   select * bulk collect into t from table(func_getNames(10));
 10   for i in 1 .. t.count loop
 11     dbms_output.put_line (t(i).id || ' ' || t(i).name);
 12   end loop;
 13  end;
 14  /
7782 CLARK
7839 KING
7934 MILLER

PL/SQL procedure successfully completed.