Nested Objects in Oracle

[Arulanand Dayalan]

Hi All,

I need to call a Stored Proc which takes in Array of Objects as input and update the Oracle DB. I am taking the following approach, but i am struck.

//Channel

create or replace TYPE Channel_List AS OBJECT (channel_id number)

//Channel Type
create or replace TYPE ChannelList AS TABLE OF number

In the above method i created Data type for Product attribute.

//Object to Inserted

create or replace TYPE PACKAGE AS OBJECT
(
PKG_PRC_ID NUMBER,
PACKAGE_ID NUMBER,
PRODUCT_TYPES ProducttypeList,
CHANNEL_ID ChannelList
)

create or replace TYPE PACKAGE _TYPE IS TABLE OF PACKAGE

After Creating this i wrote three classes,

ProductTypeDTO
ChannelTypeDTO
PackageDTO

and implemented SQL DATA.

After this i am Struck up. Product and Channel Take multiple Values, i dont how to create descriptors for it? If i dont have ProductTypeDTO and ChannelTypeDTO then i would have created Array of PackageDTO and would have handled like this,

  
ArrayDescriptor objArrDesc = ArrayDescriptor.createDescriptor("PACKAGE _TYPE", con);
ARRAY array = new ARRAY(objArrDesc, con, arrProdSeg);

where arrProdSeg is array of PackageDTO.

Thanks is Advance.

Regards,
Arul.

[Campbell Ritchie]

Bump!