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

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.


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