Varray type parameter in Function

Published on by LakshmiSaahul,Dhana Royal

> 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
To be informed of the latest articles, subscribe:
Comment on this post