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!

Oracle Apex Store images in tables and use them

VinipandaDec 8 2020

I have 2 database tables and in both of them i need to store images.
This is most popular question but none of the answers were simplified enough to understand.
Now, i did try this approach but it is throwing error while uploading image . I copied the entire approach but it failed.
How to upload an image (file) into a table (BLOB) in APEX 5 (for dummies) (0 Bytes)
Now i have two tables:
EMP: Name(varchar), Birthday(date), Photo(blob), email_from(varchar),email_to(varchar)
Birthday_wish: Date(date), Wish_image(blob)
In both tables, the photo and wish_image columns are blob.
What is the best way in which i can save employee pics and wish images in both tables?
Can i use static application files to load images? If yes then how?
P.S. The actual requirement is much bigger but i am stuck in the initial phase of storing images in table for trial.

Comments
Post Details
Added on Dec 8 2020
2 comments
2,850 views