Download XMLTYPE data as XML file on Oracle Apex page

488 Views Asked by At

My view return XMLTYPE, DATA column contains xml documents.

enter image description here

Is it possible on oracle apex page on button click, on page load or other way download this as eg. TEST.XML file

When load query in classic report and set Atributes > Apperancees > Template type : Predefineon page load documents downloads but after open xml file get:

<?xml version="1.0" encoding="utf-8"?>
<NEW>
<ROW ROWNUM="1">
  <Data>[SYS.XMLTYPE]</Data>
</ROW>
</NEW>

This is not good!

0

There are 0 best solutions below