Does subsequent BULK COLLECT into collection truncate the existing rows?
TYPE t_tab_prds IS TABLE OF my_cursor%TYPE;
v_tab_prds t_tab_prds;
OPEN my_cursor;
FETCH my_cursor BULK COLLECT INTO v_tab_prds;
CLOSE my_cursor
another session may change/delete rows
OPEN my_cursor;
FETCH my_cursor BULK COLLECT INTO v_tab_prds; -- WILL v_tab_prds be zapped before the second FETCH or will the rows be mixed? Do I need to
-- delete the rows manually from v_tab_prds before the second FETCH?
CLOSE my_cursor