SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi
PL/SQL Release 10.2.0.2.0 - Production
CORE    10.2.0.2.0      Production
TNS for HPUX: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production

  1  declare
  2  type record_emp is record
  3  (l_empno emp.empno%type,
  4   l_ename emp.ename%type,
  5   l_job   emp.job%type
  6  );
  7  type table_emp is table of record_emp;
  8  vr_emp table_emp;
  9  cursor c1
 10  is
 11  select empno, ename, job from emp;
 12  begin
 13  open c1;
 14  fetch c1 bulk collect into vr_emp limit 10;
 15  for i in vr_emp.first .. vr_emp.last
 16  loop
 17      dbms_output.put_line('Empno : ' || vr_emp(i).l_empno);
 18      dbms_output.put_line('Ename : ' || vr_emp(i).l_ename);
 19  end loop;
 20  close c1;
 21* end;
SQL> /
Empno : 7839
Ename : KING
Empno : 7698
Ename : BLAKE
Empno : 7782
Ename : CLARK
Empno : 7566
Ename : JONES
Empno : 7788
Ename : SCOTT
Empno : 7902
Ename : FORD
Empno : 7369
Ename : SMITH
Empno : 7499
Ename : ALLEN
Empno : 7521
Ename : WARD
Empno : 7654
Ename : MARTIN

PL/SQL procedure successfully completed.