Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to download a blob file

user8966924Dec 4 2013 — edited Dec 5 2013

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.

This post has been answered by JMcG on Dec 4 2013
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 2 2014
Added on Dec 4 2013
2 comments
726 views