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!

Opening/Downloading a File saved in Blob Variable - APEX 21.2

McRiversJan 11 2022 — edited Jan 11 2022

I'm using ORA_EXCEL PL/SQL API to create custom Excel files. I have it set so that when clicking a button it calls a `GENERATE_EXCEL_PROCESS` via a page submit and builds the file and saves it to a Blob (confirmed file creation is working in separate test writing file to an Oracle Directory). My goal is to generate the Excel file, save to a blob and then display a download dialog for users to save the excel file locally similarly to the native `Download` link that Classic reports allow you to turn on declaratively.
When run I get a weird APEX error, that I only found by turning Full Trace mode on in debugging. I've included the code below, but I do not know what it means to troubleshoot further. It looks like I get a response back looking at network tab in devtools.
Anyone have any ideas or come across something like this?
ora_excel_apex_error.pngora_excel_apex_error_zoom.pngexcel_test_response.png
excel_apex_test.txt (1.15 KB)

This post has been answered by Geert01 on Jan 12 2022
Jump to Answer
Comments
Post Details
Added on Jan 11 2022
2 comments
1,748 views