Hello,
Is it possible to download an Interactive Report in APEX 5 to XML format? I've tried to use Pavel's plugin - GPV Interactive Report to XML
http://www.apex-plugin.com/oracle-apex-plugins/process-type-plugin/gpv-interactive-report-to-xml_392.html
however, I get the following message when I click on my download_to_xml button;
"Report refreshed. Please try download again"
To make things as simple as possible my Interactive report SQL code is;
select * from dual;
If I change the "Return Data" attribute of the process to "Debug Information" and then re-run the page and click the button to download, I get a log file download (attached for review). Basically the log file gives the following error;
Error in IR_TO_XML.get_report_document ORA-20001:ORA-00936: missing expression
ORA-06512: at "TEST.IR_TO_XML", line 895
ORA-06512: at "TEST.IR_TO_XML", line 910
ORA-06512: at "TEST.IR_TO_XML", line 988
Has anyone used this plugin and can tell help OR can suggest another way of doing this?
Regards,
David