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!

how to show pdf or word icons for a BLOB column in a report?

Yawei ZhangAug 15 2011 — edited Aug 15 2011
Hi,

I am getting interested for the blob columns, I have created some columns for storing some pdf drawings and pictures for specific items in a table, it is ok to show a text like 'download' or any other text in the report by setting the following blob attribute:

DOWNLOAD:TICKET_DETAILS:ATTACHMENT:TICKET_DETAILS_ID::MIME_TYPE:FILE_NAME:::inline:Download

but instead of texts, I would like to show a small pdf image for my Blob file, or a word image or Excel image, according to the different file type.

how to do that?


and instead of inline or attachment this two options, I would like when the user click the image of the file, the browser will show the image in a new window, or a new browser tab.

I tried the inline option for my file at Google Chrome, but when it showed the pdf file within the browser, I cannot get back to my app by clicking the 'backward' icon at the browser menu, it will stuck there and I have to close the broswer and then login to the app again, instead of simply returning back to the previous page within the app.

Please help me out.

Thanks

Peter Yawei . Zhang
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 12 2011
Added on Aug 15 2011
1 comment
3,166 views