Fwd: XML

Toad for Oracle & DevOps Toolkit
1

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

2

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…

3

SEE ATTACHMENT

moz-screenshot-37.png
moz-screenshot-37.png641×552 28.6 KB

4

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…