RE: Fwd: XML

I saved your data and it worked fine for me (using IE9).

When you save the file, how is it encoded? (UTF8, etc)?  Maybe your browser doesn't like the encoding...

From: [email protected] [mailto:[email protected]] On Behalf Of Aci Polajnar
Sent: Wednesday, March 07, 2012 3:29 AM
To: [email protected]
Subject: [toad] Fwd: XML



Hi

I am trying to generate XML output trough Master Detail Browser option.
Please, find SQL request generated by modul:

select sys_xmlgen (
xmlelement ("DATA_RECORD"
,xmlelement ("OW_DATALOAD"
,xmlelement ("DATALOAD_ID", m.DATALOAD_ID)
,xmlelement ("NAME", m.NAME)
,xmlelement ("TXT", m.TXT)
,xmlagg (xmlelement("OW_DATALOADX"
,xmlelement ("DATALOAD_ID", d0.DATALOAD_ID)
,xmlelement ("DATALOAD_IDX", d0.DATALOAD_IDX)
,xmlelement ("NAME", d0.NAME))
order by d0.DATALOAD_ID)))
,xmlformat('main')) XMLDATA
from QUEST.OW_DATALOAD m
,QUEST.OW_DATALOADX d0
where m.DATALOAD_ID = d0.DATALOAD_ID
group by m.DATALOAD_ID, m.NAME, m.TXT

It seems OK and also output looks fine. Here is an example:

<?xml version="1.0"?>
<main>
<DATA_RECORD>
<OW_DATALOAD>
<DATALOAD_ID>5</DATALOAD_ID>
<NAME>Arleen Tireman</NAME>
<TXT>Capitol College</TXT>
<OW_DATALOADX>
<DATALOAD_ID>5</DATALOAD_ID>
<DATALOAD_IDX>662</DATALOAD_IDX>
<NAME>Plymouth</NAME>
</OW_DATALOADX>
<OW_DATALOADX>
<DATALOAD_ID>5</DATALOAD_ID>
<DATALOAD_IDX>7577</DATALOAD_IDX>
<NAME>Swansea</NAME>
</OW_DATALOADX>
<OW_DATALOADX>
<DATALOAD_ID>5</DATALOAD_ID>
<DATALOAD_IDX>7143</DATALOAD_IDX>
<NAME>Manchester</NAME>
</OW_DATALOADX>
<OW_DATALOADX>
<DATALOAD_ID>5</DATALOAD_ID>
<DATALOAD_IDX>7125</DATALOAD_IDX>
<NAME>Aberdeen</NAME>
</OW_DATALOADX>
<OW_DATALOADX>
<DATALOAD_ID>5</DATALOAD_ID>
<DATALOAD_IDX>1832</DATALOAD_IDX>
<NAME>Brighton and Hove</NAME>
</OW_DATALOADX>
<OW_DATALOADX>
<DATALOAD_ID>5</DATALOAD_ID>
<DATALOAD_IDX>2738</DATALOAD_IDX>
<NAME>Wells</NAME>
</OW_DATALOADX>
<OW_DATALOADX>
<DATALOAD_ID>5</DATALOAD_ID>
<DATALOAD_IDX>8</DATALOAD_IDX>
<NAME>Newcastle upon Tyne</NAME>
</OW_DATALOADX>
<OW_DATALOADX>
<DATALOAD_ID>5</DATALOAD_ID>
<DATALOAD_IDX>1483</DATALOAD_IDX>
<NAME>Worcester</NAME>
</OW_DATALOADX>
<OW_DATALOADX>
<DATALOAD_ID>5</DATALOAD_ID>
<DATALOAD_IDX>1344</DATALOAD_IDX>
<NAME>Wakefield</NAME>
</OW_DATALOADX>
<OW_DATALOADX>
<DATALOAD_ID>5</DATALOAD_ID>
<DATALOAD_IDX>1115</DATALOAD_IDX>
<NAME>Lichfield</NAME>
</OW_DATALOADX>
</OW_DATALOAD>
</DATA_RECORD>
</main>

But, I am not able to open this file with any kind of web browser. MS
Explorer shows nothing, Firefox gives me an error message:
Parsing error, Line 1, Column 1

Please, help