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

Hallo,

 

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)

      INSERT INTO IMAGE_TB (ID,IMAGE)
       VALUES (IMAGE_SEQ.NEXTVAL, :ITINERARY_MAP.IMAGE);

 

 

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

 

Thanks

Legend

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