Hello All,
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
http://awads.net/wp/2012/03/12/how-to-download-blob-content-as-a-file-using-oracle-application-express/
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.