XML Database (MOSC)

MOSC Banner

best way to aggregate multiple XML fragments into one XML document and pass result to an XQuery.

edited Oct 1, 2013 5:19AM in XML Database (MOSC) 1 commentAnswered
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center