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!

Re: Problem providing download link for BLOB data in apex report

user3003326Oct 30 2013 — edited Oct 30 2013

Hi Don,

Your solution below worked but in the download option i only see save but not open for PDf file in the blob. Please let me know if you have any suggestion to achieve it

Thanks

Jo

Problem providing download link for BLOB data in apex report 

591953 Explorer

 

Currently Being Moderated

 

Good morning,

Here is how I have solved this problem.

1. The select statement in the sql for the report should not include the BLOB column. I decided to select only 2 columns, the column that has the key and the column with the filename.
2. On the first column ( the primary key ) I put in the format statement that was simply DOWNLOAD:TABLENAME:BLOB_COLUMN:PRIMARY_KEY

This works. I believe that the Oracle error I was getting was because I was trying to apply this format statement to the actual BLOB column.

So, it appears that you can use any of the columns in the report to hold the DOWNLOAD format statement since in the format statement, you are defining the BLOB table, BLOB column and the primary key into that column.


Hope this helps,
Don.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 27 2013
Added on Oct 30 2013
1 comment
1,492 views