Generating multi-level XML in Oracle 8i using XML-SQL utility
Oracle 8i has a limitation when it comes to the object types. Only two-level nesting of collection is allowed. Oracle 9i apparently resolves this limitation.
I am trying to generate XML for a hierarchical (conceptually) structure. To do that I am using XML-SQL utility (XSU) running agains an object view build on top of the relational data. The problem is the limit to two levels of colelction nesting. Oracle 8i gives you a way to create a view with more levels of nesting by using references. The problem is that when XSU runs agains a view with teh references, it inserts the references into the XML document (instead of dereferencing them).
Is there a way to generate XML with Oracle 8i with more than two levels of collection nesting?
Thank you.
Michael