Unable to download a blob file

user8966924 Dec 4, 2013 9:19 AM

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.

1. Re: Unable to download a blob file

JMcG Dec 4, 2013 12:06 PM (in response to user8966924)
Currently Being Moderated

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

Thanks!

JMcG
Report Abuse

Like (0)
2. Re: Unable to download a blob file

user8966924 Dec 5, 2013 2:29 AM (in response to user8966924)

Currently Being Moderated

Thanks alot JMcG. It worked for me :-)
Report Abuse

Like (0)