best way to aggregate multiple XML fragments into one XML document and pass result to an XQuery.
Hi all,
I have two tables in a parent child relationship and each table stores an XML Fragment related to the particular row in the table (the XML having previously been parsed by IBM Message Broker). I need to be able to aggregate multiple XML fragments into one document and at the same time strip the Namespace information from the document. I've come up with the query below but I'm unsure of a couple of things:
1. When I try and pass the result of the XMLAGG into the PASSING clause of the XQuery I get an error saying the expression is of the wrong type. I have to use SYS_XMLAGG instead but this adds ROWSET elements to the beginning and end of the document.
I have two tables in a parent child relationship and each table stores an XML Fragment related to the particular row in the table (the XML having previously been parsed by IBM Message Broker). I need to be able to aggregate multiple XML fragments into one document and at the same time strip the Namespace information from the document. I've come up with the query below but I'm unsure of a couple of things:
1. When I try and pass the result of the XMLAGG into the PASSING clause of the XQuery I get an error saying the expression is of the wrong type. I have to use SYS_XMLAGG instead but this adds ROWSET elements to the beginning and end of the document.
0