SQL> SQL> set serveroutput on SQL> declare 2 type c1_type is table of test2.c1%type; 3 type c2_type is table of test2.c2%type; 4 type c3_type is table of test1.sumc2%type; 5 x c1_type; 6 y c2_type; 7 w c3_type; 8 begin 9 select c1,c2 bulk collect into x,y from test2; 10 FORALL i in 1..x.count 11 select sumc2 BULK COLLECT INTO w from test1 where c1=x(i); 12 end; 13 / FORALL i in 1..x.count * ERROR at line 10: ORA-06550: line 10, column 1: PLS-00432: implementation restriction: cannot use FORALL and BULK COLLECT INTO together in SELECT statements SQL> SQL> spool off