One of the bread and butter jobs of being an ORACLE Forms developer is loading user files through the application. Now that I am learning APEX, I find that internet documentation skirts around this, and if I am reading it correctly, such a thing cannot be done. Instead, you have to upload the file to the server first. Even then, I find internet information a bit hard to follow on this topic. Can someone provide a simple example to allow a user to upload a file for use in an APEX application.
Vinish Kapoor
You want to upload data (CSV) to the tables using the Oracle Apex page or want to load PDFs, images to a table having a BLOB column?
By the way, both can be done.
To upload the CSV data, use the data load wizard. To load the PDF or image files using the file browse item.
Please let me know if my assumption is not correct.
Greg
I want to use the file browse item, but I am lost between selecting a file and that file ending up in APEX_APPLICATION_TEMP_FILES. Can you explain that bit of magic to me please?
Vinish Kapoor
You can also use "Blob column specified in the item source" option. And below are the details of both the options:
Storage Type
Select the database table where the uploaded file is stored.
Available options include:
To access a file if Allow Multiple Files is set to No:
To access files if Allow Multiple Files is set to Yes:
Greg
I finally found the missing piece of the puzzle. I had the file browse field and I had a button, but I was unsure as to what I should tell the button to do. Apparently, for the button's Behaviour > Action, you select Submit Page.
Vinish Kapoor
Yes, so that it can be saved by the process written on the process tab.