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!

Another INSERT BLOB into a table question

474742Apr 7 2008 — edited Apr 10 2008
After searching a bit through the forum, I'm not seeing anything that seems to answer my question on this well beaten topic.

Trying to do a simple task of allowing a user to enter an ID number into Field 1 on a form, then want to let user File Browse for a JPEG image in Field 2. Want the Submit button to INSERT the ID # into column 1 and the JPEG image into column 2 of a 2 column simple table. In a separate report page, I want the user to be able to show the ID# and it's associated JPEG image next to it.

So far I've seen several things that seem to come close, but nothing seems to cover this task from start to end.

I'm coming back to Apex from 2 years off, and had little experience with PL/SQL prior to this so I'm not well versed in making procedures or functions or when/how to call them.

Can this be simply done in APEX? So far, creating a number column and a BLOB column and adding them both to the form only reveals in ID field and not the BLOB. Even if I create a separate field that let's one browse for a file and insert it into the BLOB column I get a cannot insert NULL into the blob column. So I guess the browse to value is not being interpreted simply as to upload the jpeg image into the table as I currently think it would.

A simple answer exists I hope?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 8 2008
Added on Apr 7 2008
14 comments
2,234 views