Hi,
I am using a table having a BLOB column used to store a user's resume (it can be a word document, a pdf file or any other binary format).
Now in Oracle Apex 4.2, when I create a form on this table, I automatically get a browse button for selecting a file for the BLOB column. I can browse through files and select a file and then I press another button (also provided automatically) to upload the file. Now if I see this record in SQL Developer or Pl/SQL developer, I see that the BLOB data is there, and I can save it to my disk or even can view it directly from database. This is all nice!
But now when I create a report on same table In Oracle APEX, and then run that report, it doesn't give me any option to view or download the binary file, instead, it only gives the text "[unsupported data type]" in the BLOB column space, no button or links to get BLOB value. I saw in Oracle APEX online documentation that when we run a report having a BLOB column APEX automatically provides a Download button.... but in actual it is not happening, and I am seeing no way of retrieving BLOB column data in Oracle APEX. Can someone please help me???
Thanks in Advance.