I have created an application which requires uploading and downloading of the files.
I have created a column in my table 'files' as BLOB type.
I am able to upload the file into the DB and it gets saved.
Now, I have created an interactive report to download the file file
I followed the following site
But it is throwing following error:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
One thing that I have observed is that eventhough my column is blob type, in the Report Attributes it shows Column Type as 'Others'
Kindly help me resolve this.
Please use dbms_lob.getlength() function on your blob datatype column. Then for your blob column, edit the "Blob Column Attributes" under "Report Attributes -> Column Formatting."
SELECT file_id, file_name, mime_type, dbms_lob.getlength(blob_content) download FROM my_files