create or replace package testpkg is
type typetest is table of varchar2(10) index by binary_integer;
function insTest1(tTest in typetest )return number;
end testpkg;
--主体
create or replace package body testpkg is
function insTest1(tTest in typetest )return number
is
begin
insert into test values
(to_number(ttest(1)),ttest(2),ttest(3),to_number(tTest(4)),10);
return 0;
end insTest1;
end testpkg;
怎么在sqlplus调用输入参数为集合类型的包函数?-
===============
SQL> declare
2 type typetest is table of varchar2(10) index by binary_integer;
3 tTest typetest ;
lv number(5);
4 begin
5 tTest(1) :='1';
6 tTest(2) :='1';
7 tTest(3) :='1';
lv := testpkg.insTest1(tTest);
8 end;
9 /
=======
declare
v_tTest testpkg.typetest:=testpkg.typetest(1,2,3,4);
num number;
begin
num:=testpkg.insTest1(v_tTest);
dbms_output.put_line(num);
end;
/