Problem with XMLSerialize / indented XML
My Problem is that my XML output is only one line like:
<?xml version="1.0" encoding="ISO-8859-15"?><rss version="2.0"><channel><title>Test</title></channel></rss>
Iam interested in exporting xml like that:
<?xml version="1.0" encoding="ISO-8859-15"?>
<rss version="2.0">
..<channel>
....<title>Test</title>
..</channel>
</rss>
I heard something about xmlserialize which should be used like that:
select xmlserialize(DOCUMENT xmltype('<?xml version="1.0" encoding="ISO-8859-15"?><rss version="2.0"><channel><title>Test</title></channel></rss>')) from dual;
but its no change in my output.
Can someone help me?
Edited by: Oliver L on 07.11.2008 14:15