drop table ptab;
create table ptab(name varchar2(20));
create or replace package mypkg as
type arrtype is table of varchar2(20) index by pls_integer;
procedure myproc(p1 in out arrtype);
end mypkg;
/
create or replace package body mypkg as
procedure myproc(p1 in out arrtype) is
begin
forall i in indices of p1
insert into ptab values (p1(i));
end myproc;
end mypkg;
/
|