create or replace package xxx as type table1set is table of table1%rowtype index_by binary_integer; type table2set is table of table2%rowtype index_by binary_integer; procedure yyy (a in int,tab1 inout table1set,tab2 inout table2set); end xxx; create or replace package body xxx as procedure yyy (a in int,tab1 inout table1set,tab2 inout table2set) as begin if(a==1) select * into tab1 from table1; elsif select * into tab2 from table2 endif; end yyy; end xxx;
type table1set is table of table1%rowtype index_by binary_integer;
type table2set is table of table2%rowtype index_by binary_integer;
procedure yyy (a in int,tab1 inout table1set,tab2 inout table2set);
end xxx;
create or replace package body xxx as
procedure yyy (a in int,tab1 inout table1set,tab2 inout table2set) as
begin
if(a==1)
select * into tab1 from table1;
elsif
select * into tab2 from table2
endif;
end yyy;
end xxx;