2 Replies Latest reply on Apr 26, 2013 2:14 PM by gerhard2001

    Form with File upload

      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.

        • 1. Re: Form with File upload
          Hilary Farrell-Oracle
          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

          and Chapter 17, section 18.10 About BLOB Support in Forms and Reports

          • 2. Re: Form with File upload
            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