Fwd: XML
Aci Polajnar <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <[email protected]> |
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
------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)
<*> To change settings via email:
[email protected]
[email protected]
<*> To unsubscribe from this group, send an email to:
[email protected]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/