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!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
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? excel_apex_test.txt (1.15 KB)
Could this be of any help: Apex Office Print (AOP) - Error: SyntaxError: Unexpected token % in JSON at position 0 - Zero Integration Ltd. (0 Bytes)
YES! Thank you so much. I wish the article went in to more detail of what was happening and why this fixes it. Would love to learn more. Regardless, I appreciate you sharing this with me to help me out.