Skip to Main Content

APEX 5 paste image and save to database as blob

melinda_fNov 28 2016 — edited Dec 7 2016

APEX 5 against 10g, use IE 11 and Firefox.

I'm developing a test execution system, and need to provide users with the ability to capture a screen shot, paste it into a field and save that as a blob in the database that can be downloaded as an image file.

I saw which sounds like exactly what I need to be able to do but I never saw a resolution. 

I tried providing a rich text editor to paste into and used the plug in found here https://github.com/OraOpenSource/apex-plugin-clob-load along with code to convert clob to blob to save to the database.  It appeared to save and there were no errors saving however whenever I tried to download the blob from an interactive report with a download column the file was not able to be read by any kind of image viewing software.  I'm guessing maybe there is some kind of encoding step I am missing but am outside of my area of expertise.  Any suggestions?

Comments
Post Details
Added on Nov 28 2016
8 comments
1,749 views