Another INSERT BLOB into a table question
474742Apr 7 2008 — edited Apr 10 2008After 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?