Interactive Report will not save BLOB Column Attributes
jtblairDec 11 2012 — edited Dec 12 2012I 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