This discussion is archived
2 Replies Latest reply: Dec 5, 2013 2:29 AM by user8966924 RSS

Unable to download a blob file

user8966924 Newbie
Currently Being Moderated

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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points