create or replace procedure impl_cursor_bulk as TYPE test1_tab IS TABLE OF dba_source%ROWTYPE; t_tab test1_tab; begin select * bulk collect into t_tab from dba_source; dbms_output.put_line(t_tab.COUNT); end; / create or replace procedure expl_cursor_bulk as TYPE test1_tab IS TABLE OF dba_source%ROWTYPE; t_tab test1_tab; cursor test_cur is select * from dba_source; begin open test_cur; fetch test_cur bulk collect into t_tab; close test_cur; dbms_output.put_line(t_tab.COUNT); end; / exec runStats_pkg.rs_start; exec expl_cursor_bulk; exec runStats_pkg.rs_middle; exec impl_cursor_bulk; exec runStats_pkg.rs_stop;