All,
I'm having a beast of a time trying to figure out how to use BLOBs in a report. According to the documentation, I can select a BLOB column in the query for an interactive report and then specify a BLOB format mask, but when I do this, displaying the column results in my report being replaced by the "No data found" message (even though I'm not changing the filter options).
My setup:
I've got a table with the report data which contains an ID linking to a second table with the file data. The report currently grabs both the ID and the BLOB column itself, simply because I'm trying to figure out how this works. If I don't apply a format mask to the BLOB column, it shows as "[unsupported data type]". But when I specify a format mask:
IMAGE:A103_FILES_V:FILE_DATA:FILE_ID::MIME_TYPE:FILENAME:::inline:Download
...everything blows up and I get "ORA-01403: no data found". I've verified the table name and column names, and that there is data in a103_files_v for the records in the report (I've even tried filtering down to a single row).
I found
this thread which talks about using dbms_lob.getlength(...) for the column which has the format mask. This makes...extremely little sense to me. But, still, I tried doing that, with the same result. I also tried placing the format mask on the column with the ID, but got the same behavior.
What am I missing? Which column does the BLOB format mask go on, and if it's not the ID, why does it need the primary key column to the file table? Where does it get the ID from?
Also, it's less than helpful that the sample application ducks the question entirely by using apex_util.get_blob_file_src(...). I'm just saying.
Thanks,
-David