Increase varray size!

varray.sql

CREATE OR REPLACE TYPE NUMBER_ARRAY AS VARRAY(2) OF NUMBER


create table tab_with_arr(
  id  number,
  val NUMBER_ARRAY)

insert into tab_with_arr
select 1, number_array(1,2,3,4,5)
from dual

-- Error!

insert into tab_with_arr
select 1, number_array(1,2)
from dual

-- ok!

ALTER TYPE NUMBER_ARRAY MODIFY LIMIT 5 INVALIDATE;

insert into tab_with_arr
select 1, number_array(1,2,3,4,5)
from dual

-- ok!
    

select t.id, c.column_value
from tab_with_arr   t,
     table(t.val)   c