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.
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,