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!

Interactive Report will not save BLOB Column Attributes

jtblairDec 11 2012 — edited Dec 12 2012
I have created many interactive reports with 4.0 and 4.1 that had BLOB columns with no problems and the download link worked fine. After upgrading to 4.2, the interactive reports get the following error when clicking on the download link:
Not found
The requested URL /apex/apex_util.get_blob was not found on this server

If I open the edit page from the report, the BLOB downloads fine. When I looked at the report attributes details for the BLOB column, I noticed the BLOB Column Attributes had not been populated. I have tried repeatedly to populate them (Table Name, Column Name, Primary Key, MIMETYPE, etc.) but after applying the changes and reopening the attributes page for the blob column, the values I entered are not saved.
For completeness, here is the select statement for the report:
select "DESC_ATT_ID",
"BR_ID",
"FILENAME",
"MIMETYPE",
dbms_lob.getlength("DESC_ATTACHMENT") "DESC_ATTACHMENT"
from "#OWNER#"."ALTEC_BR_DESC_ATT"
WHERE BR_ID = :P3_BR_ID

Also, here is the value for the Number/Date format for the BLOB Column:
DOWNLOAD:ALTEC_BR_DESC_ATT:DESC_ATTACHMENT:DESC_ATT_ID

Can someone please point me in the right direction to get the link for the interactive report working properly?
Many thanks,
Jerry
This post has been answered by fatehcis-JavaNet on Dec 12 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 9 2013
Added on Dec 11 2012
1 comment
507 views