IR Query : select "ROWID","FILE_NAME",dbms_lob.getlength("DATA_FILE") "DATA_FILE",
I am using BLOB Download Format Mask on FILE_NAME column
using the following FORMATTING
After applying the changes, I counter the error
The number of display columns in the report reached the limit. Please click Select Columns under Actions menu to minimize the report display column list.
Here you can find a tutorial about blob:
I have a demo here - it shows how to display an image in case the file is image. Otherwise, it displays download link:
Also, there is a packaged application : Sample File Upload and Download that shows you, how to do it.....
you can find it on your workspace.. or here if you wish:
If you believe that my answer was helpful to you or correct, then please mark the answer as helpful or correct ...