Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

How to save a pdf (invoice) into database blob column created using plsql dynamic content in apex.

Rafsun JanyJan 24 2023 — edited Jan 25 2023

I created an invoice using plsql dynamic content in oracle apex where I used HTML CSS and javascript to design the invoice after that I converted the div (invoice div) into pdf using jspdf plugin. Now I want to save the pdf into my database blob column.
I tried to convert the pdf into base64 and placed that base64 into an item. But the length of base64 is around 300000 and when I tried to send it using ajax callback in the plsql process it could not capture the item value and shows null.
What could be the easiest solution in this aspect?
Thanks.

Comments
Post Details
Added on Jan 24 2023
8 comments
625 views