DECLARE TYPE t_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; v_bulk t_tab; v_copy t_tab; PROCEDURE p_bulk IS BEGIN SELECT level BULK COLLECT INTO v_bulk FROM DUAL CONNECT BY level < 11; END p_bulk; BEGIN p_bulk; DBMS_OUTPUT.PUT_LINE(' Array Size = '||v_bulk.COUNT); v_bulk.DELETE(5); DBMS_OUTPUT.PUT_LINE(' Array Size = '||v_bulk.COUNT); FORALL idx IN INDICES OF v_bulk INSERT INTO load_sequence_lookup (load_sequence, load_id) SELECT v_bulk(idx), 1 FROM DUAL; END; / --> Output
73986