I have run across a problem of trying to view XML but then having some kind of hassle with the browser showing the XML. This is a little work around to show the XML in a local application, I use Notepad++ First need to add the option to view XML with Excel. Sys Admin \ Install \ Viewer Options The next is to change the default in the profile to view the XML with Excel as a default. If you leave this null it will ask you each time so you could do it that way. Sys Admin \ Profile \ System Next is the little work around. You need to save the file locally as xml. So instead of opening it with Excel you save it as xml and then you can open it locally and see all the data as required. Save locally
Working my way through the dba day to day activities sharing what I learn along the way. Mostly a place to save my own notes for later use and hopefully someone else might find it useful.