assignments to varray elements, and the ORA-6532 and ORA-6533 errors.
SQL>
SQL>
SQL> DECLARE
2 TYPE Strings IS VARRAY(5) OF VARCHAR2(10);
3 v_List Strings :=
4 Strings('One', 'Two', 'Three', 'Four');
5 BEGIN
6 v_List(2) := 'TWO';
7
8 v_List.EXTEND;
9 v_List(5) := 'Five';
10
11 -- Attempt to extend the varray to 6 elements. This will
12 -- raise ORA-6532 .
13 v_list.EXTEND;
14 END;
15 /
DECLARE
*
ERROR at line 1:
ORA-06532: Subscript outside of limit
ORA-06512: at line 13
SQL>
SQL>
SQL>
SQL>
Related examples in the same category