Varray type parameter in Function
> create or replace type numberlist_t 2 as varray(4) of varchar2(20); 3 / Type created. SQL> SQL> column numlist format a60 SQL> SQL> alter table e add (numlist numberlist_t)
SQL> create or replace function ext 2 (p_varray_in numberlist_t) 3 return varchar2 4 is 5 v_ext varchar2(20); 6 begin 7 v_ext := p_varray_in(1); 8 return v_ext; 9 end; 10 /
Advertising