This content has been marked as final. Show 2 replies
first question - did you simply change the output format of your concurrent request (with executable type SQL*Plus) to XML and add a template to it?
If this is the case, I am not surprised you get an error. You need to make sure you are generating actual XML output. If you run the request and then click on the 'Diagnostics' button you will see a button saying 'show XML'. Click on this to see what you get. If you get an error, then it is not correct XML.
This being the case, you have a number of options:
1. create a data template and use that to create the XML
2. use appropriate XML functions in your query to generate the XML (never tried this so can't guarantee it will work)
3. use the reports rdf file to generate the XML
4. generate the XML from PL/SQL
I would suggest you try option 2 first as it should be fairly quick & easy to test, then use option 1 as the best solution if it doesn't work.
this is exactly the case, when i click on view XML in diagnostic it is showing me the errors like
Whitespace is not allowed at this location. Error processing resource
A semi colon character was expected. Error processing resource
there was a issue with the data
Edited by: user1054040 on Apr 26, 2012 2:34 AM