Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Generating multi-level XML in Oracle 8i using XML-SQL utility

247917Mar 29 2002
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 2 2002
Added on Mar 29 2002
6 comments
454 views