i am working on oracle 9.2.0.1.0 version.

i am trying to write a procedure using bulk collect i am getting the end-of-file on communication channel. 


i tried like this 

SQL> CREATE OR REPLACE procedure insert_test
  2  as
  3
  4
  5   type p_type is table of emp%rowtype ;
  6   p_row p_type;
  7
  8  BEGIN
  9
 10     select * bulk collect into p_row from emp ;
 11
 12  END;
 13  /
SQL> exec insert_test;
SQL>


it is working fine for me 

but i am trying since two days but i am unable to trace why the problem.


SQL> desc test;
 Name
                                               Null?    Type
 -----------------------------------------------------------------------------------------------------------------------
------------------------------------------------------ -------- --------------------------------------------------------
------------------------------------------------------------
 P_ID
                                               NOT NULL VARCHAR2(15)
 SEQ_NO
                                               NOT NULL NUMBER
 ITEM_NAME
                                                        VARCHAR2(2000)
 DESCRIPTION
                                                        VARCHAR2(4000)
 SCHEDULE
                                                        DATE
 ITEM_TYPE
                                               NOT NULL VARCHAR2(8)
 COMPLETION_DATE
                                                        DATE
 NA
                                                        NUMBER

SQL>
SQL> select * from test;

Execution Plan
----------------------------------------------------------
   0      SELECT STATEMENT Optimizer=CHOOSE
   1    0   TABLE ACCESS (FULL) OF 'TEST'




Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
          0  consistent gets
          0  physical reads
          0  redo size
          0  bytes sent via SQL*Net to client
          0  bytes received via SQL*Net from client
          0  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
      83888  rows processed

SQL> CREATE OR REPLACE procedure insert_test
  2  as
  3
  4
  5   type p_type is table of test%rowtype ;
  6   p_row p_type;
  7
  8  BEGIN
  9
 10     select * bulk collect into p_row from test ;
 11
 12  END;
 13  /
SQL> exec insert_test;
BEGIN insert_test; END;

*
ERROR at line 1:
ORA-03113: end-of-file on communication channel


Is it depends on the size of the table? 
i am thankful for your suggestions.