>The presentation went into detail about not all queries will >use array processing - only 'static sql cursor for loop' which >in the presentation has the form > >for j in (select ... From tbl) >Loop >Yada yada; >End loop;
This is true. In fact a PL/SQL block like the following doesn't use = prefetching.
declare cursor c is select * from all_tables; t all_tables%rowtype; begin open c; loop=20 fetch c into t; exit when c%notfound; end loop; end;
HTH Chris -- http://www.freelists.org/webpage/oracle-l
