legal and illegal varray assignments.
SQL>
SQL> DECLARE
2 TYPE Strings IS VARRAY(5) OF VARCHAR2(10);
3
4 v_List Strings := Strings('One', 'Two', 'Three');
5 BEGIN
6 v_List(2) := 'TWO';
7
8 -- Subscript beyond count, raises ORA-6533.
9 v_List(4) := '!!!';
10 END;
11 /
DECLARE
*
ERROR at line 1:
ORA-06533: Subscript beyond count
ORA-06512: at line 9
SQL>
SQL>
Related examples in the same category