Toad World® Forums

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:

5
Arleen Tireman
Capitol College

5
662
Plymouth

5
7577
Swansea

5
7143
Manchester

5
7125
Aberdeen

5
1832
Brighton and Hove

5
2738
Wells

5
8
Newcastle upon Tyne

5
1483
Worcester

5
1344
Wakefield

5
1115
Lichfield

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

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…

SEE ATTACHMENT

Hi, me again.

If I use Google Chrome I get the message: This XML file does not appear to have
any style information associated with it. The document tree is shown below.

Regards!

On 7.3.2012 15:06, John Dorlon wrote:

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…