1

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!

babayaro
  • 491
  • 3
  • 15
  • 1
    you can use interactive report and check the following link: https://oracle-base.com/articles/misc/apex-tips-file-download-from-a-button-or-link – cengiz sevimli Sep 02 '22 at 08:29
  • @cengizsevimli Tnx for answer, is blob content in your link example my data column? Also I don't have mime type. – babayaro Sep 02 '22 at 11:14

0 Answers0