CONVERT ORACLE'S XML TO AN ADO RECORDSET'S XML

[caranjo]

Hi all,

The XML that gets dumped out of ORACLE resembles the following:
<?xml version = '1.0'?>
<rowset>
<row num ="1">
<a>abc</a>
<b>def</b>
<c>...</c>
</row>
</rowset>

But I need it to look like:

<xml xmlns:s="...">
<rs:row>
<z:row a = "abc" />
<z:row b = "def" />
<z:row a = "..." />
</rs:row>
</xml>

Does anybody have any way to make this conversion?

Thanks in advance!!

Carlos

 

[tsuji]

You should not use element name starting with the sequence "xml" in any case combination. So the question is no good before it starts making sense. (Besides, what are s, rs,z... or are there some typo? or are they distinct?)