I have created a report with a form in Oracle Apex, for this report I am using a table that have 5 columns and 1 of the columns is filename varchar2(500) which is support to hold a file. In the form I have a page item that uploads the file, however when I create a new record in the form, that records is added without the file uploaded.
Any ideas on how to achieve this process correctly? I am sure my table column is the problem, however I do not know how to fix it.
Advertisement
Answer
Your file itself is in a column of datatype BLOB since that is binary data, but you need more columns. Check the sample app called “Sample File Upload and Download” which has a complete example with instructions on how to do this, there are also plenty of blogs around that explain the details.