oracle package中 table类型参数 调试/debug

create or replace type “t_params” is table of varchar2(32000);
–情况一:
test代码：
declare
– Non-scalar parameters require additional processing
tparams t_params := t_params();

begin
–扩展空间
tparams.extend(4);
tparams(1) := ‘aaa’;
tparams(2) := ‘bbb’;
tparams(3) := ‘ccc’;
tparams(4) := ‘dddd’;
– Call the function
:result := pkg_xxx.funXXXX(tparams => tparams);
end;

–情况二:
package：
function funXXXXX(aryParam1 in T_PARAMS, aryParam2 in T_PARAMS)
return varchar2 is

test代码：
declare
aryparam1 t_params := t_params();
aryparam2 t_params := t_params();
obj typ_XXXXXX := typ_XXXXXX(‘1’,‘2’,‘3’,‘4’,5);
begin
– Call the default constructor for the typ_XXXXXX instance
obj := typ_XXXXXX(‘1’,‘2’,‘3’,‘4’,5);

aryparam1.extend(7);
aryparam1(1) := ‘001’;
aryparam1(2) := ‘002’;

aryparam2.extend(1);
aryparam2(1) := ‘“AA,BB,CC”’;
– Call the method
:result := obj.funXXXXX(aryparam1 => aryparam1,
aryparam2 => aryparam2);
end;