Here is my current situation: I am attempting to create an object that is returned from a stored procedure and translated to XML from an oracle struct in java. In order to have the XML structured properlyu, it requires an array within an array. So below for a sample of the XML.
I decided a nested table was the best approach since it is unbounded. The problem I run into is that it doesn't appear I can have a nested table with an attribute of an object that contains a nested table as an attribute. This correlates to result_sets and entries.
I have seen documentation verifying that you can't nest varrays. Can anybodty provide some guidance on the best approach to simulating the structure needed? Any help would be greatly appreciated!
<report>
<start_date/>
<end_date/>
<result_sets>
<result_set>
<partner>
<id/>
<name/>
</partner>
<entries>
<entry>
<date/>
<volume/>
</entry>
</entries>
</result_set>
</result_sets>
</report>
I decided a nested table was the best approach since it is unbounded. The problem I run into is that it doesn't appear I can have a nested table with an attribute of an object that contains a nested table as an attribute. This correlates to result_sets and entries.
I have seen documentation verifying that you can't nest varrays. Can anybodty provide some guidance on the best approach to simulating the structure needed? Any help would be greatly appreciated!
<report>
<start_date/>
<end_date/>
<result_sets>
<result_set>
<partner>
<id/>
<name/>
</partner>
<entries>
<entry>
<date/>
<volume/>
</entry>
</entries>
</result_set>
</result_sets>
</report>
