2 Replies Latest reply: Apr 26, 2013 9:14 AM by gerhard2001 RSS

    Form with File upload

    r12appsuser
      Hello gurus ,

      I have a form with Fields that inserts into a table.

      Now I am trying to add a File browser so that i can attach documents too int another custom Table with BLOB.

      I could not figure out how to upload file and also form data (with other fields ) at the same time.

      Can you please give some directions? This is a very Urgent requirement for us.

      thanks,
      Arun
        • 1. Re: Form with File upload
          Hilary
          Hi Arun,

          For a working example, which you can easily follow, I would recommend reviewing the 'Sample Database Application', which gets installed by default are part of your workspace provisioning. The 'Product Details' page is a form page that include a File Browse item - so if you edit the page, you'll be able to see how this was implemented and mirror this in your own application.

          I would also recommend reviewing the APEX User's Guide, specifically:

          Chapter 15, Section 15.3 Securing File Uploads
          http://docs.oracle.com/cd/E37097_01/doc/doc.42/e35125/sec_sec_upload.htm#BABCICIC

          and Chapter 17, section 18.10 About BLOB Support in Forms and Reports
          http://docs.oracle.com/cd/E37097_01/doc/doc.42/e35125/advnc_blob.htm#BCGGJHEF

          Regards,
          Hilary
          • 2. Re: Form with File upload
            gerhard2001
            Hi Arun!

            Add an 'File Browse' Item to your Form.
            In the EDIT Mode you can configure this Item.

            Create a process to save the BLOB and execute it with the save button

            Gerhard