2 Replies Latest reply: Oct 1, 2013 6:25 AM by fa77 RSS

    Insert Image to table from a Non Database Field

    fa77

      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