Mega Code Archive
Subscript index values begin at 1, not 0
<![CDATA[
SQL>
SQL> DECLARE
2
3 TYPE integer_varray IS VARRAY(3) OF INTEGER;
4
5
6 intArray INTEGER_VARRAY := integer_varray(NULL,NULL,NULL);
7 BEGIN
8
9
10 FOR i IN 1..3 LOOP
11 dbms_output.put ('Integer Varray:'||i);
12 dbms_output.put_line(':'||intArray(i));
13 END LOOP;
14
15 END;
16 /
Integer Varray:1:
Integer Varray:2:
Integer Varray:3:
PL/SQL procedure successfully completed.
]]>