Create a SQL collection type that disallows null values
SQL> SQL> CREATE OR REPLACE TYPE integer_varray 2 AS VARRAY(100) OF INTEGER NOT NULL; 3 / Type created. SQL> SQL> DECLARE 2 intArray INTEGER_VARRAY := integer_varray(); 3 BEGIN 4 FOR i IN 1..intArray.LIMIT LOOP 5 intArray.EXTEND; 6 END LOOP; 7 dbms_output.put_line('['||intArray.COUNT||']'); 8 END; 9 / [100] PL/SQL procedure successfully completed. SQL>