Re: Fwd: XML

Hi John.

My encoding is UTF-8. If I open document with Firefox or MS Internet 
Explorer, I see source of dokument,
like in editor:




Pay attention to red circle with message, which means that some 
informations in my XML document are missing

Thank you and best 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...
>
> *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
>
>