Upload CLOB and BLOB as Ajax process

ino.laurensse Public · Mar 28 2022

Idea Summary
An easier way for CLOB and BLOB uploads without page submit.

Currently it takes quite some extra work in JavaScript to chunk the data, possibly convert a BLOB to base64 etc.

Use Case
Upload client side generated PDF using some JavaScript library.

Upload files without a submit.

Immediately save a photo taken with a webcam.

Preferred Solution (Optional)
Maybe CLOB and BLOB support in apex.server.process.

This is currently on the roadmap for a future release of Oracle APEX.

FR-3359: FR-3359 Need to access data from APEX_APPLICATION_TEMP_FILES with dynamic action or without page submit.

Comments

gabriel.diaz.arias OP 3.2 years ago

I did some seriously “hacking” with this in the past for being able to upload unlimited size blob and clobs trough ajax apex.server.process and I woudn't recomend doing it manually. Encoding to base64 results in even double uploaded file size compared to binary uploads. Javascript performance when chunking and encoding to base64 for very large files is also quite bad. It would be nice having an official api for this.