CREATE OR REPLACE procedure fast_proc (p_rows out number)
  is
   TYPE object_id_tab IS TABLE OF all_objects.object_name%TYPE INDEX BY BINARY_INTEGER
   lt_object_id                 object_id_tab;
   CURSOR c IS
   SELECT object_name
   FROM all_objects;
   BEGIN
       OPEN c;
    loop
       FETCH c BULK COLLECT INTO lt_object_id  ;
        FORALL i IN lt_object_id.FIRST .. lt_object_id.LAST
       insert into t2(object_name) values lt_object_id(i);
       EXIT WHEN c%NOTFOUND;
       END LOOP;
       CLOSE c;
  p_rows:=lt_object_id.LAST;
 end;
 /
Warning: Procedure created with compilation errors.

Errors for PROCEDURE FAST_PROC:

LINE/COL ERROR
-------- ---------------------------------------------------------
13/7     PL/SQL: SQL Statement ignored
13/22    PL/SQL: ORA-03001: unimplemented feature

ORA-03001: unimplemented feature
 *Cause:  This feature is not implemented.
 *Action:  None.

SCOTT@orcl_11gR2> CREATE TABLE t2 AS
  2  SELECT object_name
  3  FROM   all_objects
  4  WHERE  1 = 2
  5  /

Table created.

SCOTT@orcl_11gR2> CREATE OR REPLACE procedure fast_proc
  2  	(p_rows OUT NUMBER)
  3  AS
  4  	TYPE object_id_tab IS TABLE OF all_objects.object_name%TYPE
  5  				       INDEX BY BINARY_INTEGER;
  6  	lt_object_id		       object_id_tab;
  7  	CURSOR c IS
  8  	SELECT object_name
  9  	FROM   all_objects;
 10  BEGIN
 11  	OPEN c;
 12  	LOOP
 13  	  FETCH c BULK COLLECT INTO lt_object_id;
 14  	  FORALL i IN lt_object_id.FIRST .. lt_object_id.LAST
 15  	    INSERT into t2 (object_name) VALUES (lt_object_id(i));
 16  	  EXIT WHEN c%NOTFOUND;
 17  	END LOOP;
 18  	CLOSE c;
 19  	p_rows := lt_object_id.LAST;
 20  END fast_proc;
 21  /

Procedure created.

SCOTT@orcl_11gR2> SHOW ERRORS
No errors.
SCOTT@orcl_11gR2> VARIABLE g_rows NUMBER
SCOTT@orcl_11gR2> EXECUTE fast_proc (:g_rows)

PL/SQL procedure successfully completed.

SCOTT@orcl_11gR2> PRINT g_rows

    G_ROWS
----------
     57485

SCOTT@orcl_11gR2> SELECT COUNT (*) FROM t2
  2  /

  COUNT(*)
----------
     57485

1 row selected.

SCOTT@orcl_11gR2>