Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle APEX Download PL/SQL Sub Region

Hello,
I have a sub region on an Apex 19.2, i would like to download the code inside in pdf. I have an idea of chaging the mime-type of the page, but i would like to know the best way to do this. Does it possible to be done?
I have tryed some google int with htp.p() but that doesnt works! I can't use pl/sql package because the content can't be hold in a clob
Here is what i have tryed inside the subregion.
owa_util.mime_header('application/pdf', false);
htp.p('Content-Disposition: attachment; filename="myfile.pdf"');
owa_util.http_header_close;
but all this do is writing Content-Disposition... to the screen! :)
Any idea? Thanks for your help.

Comments

thatJeffSmith-Oracle

If you export the same data/query to another format like CSV, is the data integrity maintained there? Just trying to localize this to JUST XLS exports or a bigger problem in general.

Ora-aff

I just checked and found that the report is exported correctly in the XLS and CSV, it is only when I convert .xls into OpenOffice Spreadsheet, the data integrity is lost.

1 - 2

Post Details

Added on Jun 10 2021
3 comments
405 views