This discussion is archived
2 Replies Latest reply: Oct 1, 2013 4:25 AM by fa77 RSS

Insert Image to table from a Non Database Field

fa77 Newbie
Currently Being Moderated



db- 9i EE R2

forms - 6i R2

OS - W2003


I have a requirement to upload Images to the database from forms.

I planned to keep the transaction data and the Images separately in different tables with a reference.

So, I created the Image field (BLOB)  with a Non Database Field in the Form and use a button to upload the Image. (using READ_IMAGE_FILE).

I tried to insert the Image to the Actual Image table in PRE-INSERT Trigger at block level.

But I was not able to Insert the using reference method.  (Cannot compile the PRE-INSERT)




So, Please help me to insert a image to different table from a Non Database Field?




  • Correct Answers - 10 points
  • Helpful Answers - 5 points