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/
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.