Nested table input/output

[Arvid]

I have package specification looking like this:

CREATE OR REPLACE
PACKAGE webuser.pkg_arvidtest2
IS
TYPE rt_ProductInfo IS RECORD (inStock number(4,0),
Name varchar2(100));

TYPE tt_ProductInfo IS TABLE OF rt_ProductInfo;

TYPE rt_HouseInfo IS RECORD (ID number(3,0),
Adress varchar2(1024),
Products tt_ProductInfo
);

TYPE tt_HouseInfo IS TABLE OF rt_HouseInfo;

TYPE rt_custinfo IS RECORD (CustNo number(3,0),
Firstname varchar2(100),
Lastname varchar2(100),
HouseInfo tt_HouseInfo
);

procedure get_custInfo(inCustNo in number, outCustInfo out rt_custinfo);

procedure Set_custinfo(inCustInfo in rtCustInfo);

end;

I have tried using package wizard to call get_custinfo and set_custinfo. But I can not make it work. Any suggestions on how to make nested table calls work?

 

[Marco Kalter]

This will not work with a nested table type that is declared in the package. You can only use standalone nested table types PL/SQL Tables (TYPE tt_ProductInfo IS TABLE OF rt_ProductInfo index by binary_integer).