Unable to download a blob file

user8966924 Dec 4, 2013 5:19 PM

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 8:06 PM (in response to user8966924)
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
Like Show 0 Likes(0)

Actions
2. Re: Unable to download a blob file

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

Thanks alot JMcG. It worked for me :-)
Like Show 0 Likes(0)

Actions

Join the world’s largest interactive community dedicated to Oracle technologies.