Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to merge 2 XML streams together?
I need to generate an XML stream to send to another server. The
output will consist of a number of rows from 2 different
tables. Depending on the table the row came from, the XML needs to be
formatted somewhat differently. However, I need to
send all of the output as 1 continuous XML stream, with all of the
output from table 1 together followed by the output from the
second table. I am trying to use Oracle's XSQL servlet to generate
the XML and then use an XSL file to format appropriately.
Is there a way for me to 'merge' XML streams together in 1 XML
stream??
(for example,
<request type = "1">
<query>select * from table1</query>
<querydate>08/20/2001</querydate>
<id>1</id>
<id>1a</id>
</request>
<request type = "2">
<query>select * from table2</query>
<library>lib2</library>
<id>2</id>
<id>2a</id>
</request>
Received on Tue Aug 21 2001 - 09:52:20 CDT