This content has been marked as final. Show 6 replies
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,
I have the same problem. I have the following query:
select name, description,
It ran fine and return the records back. But when I put the blob format on, it returned with the "ORA-01403: no data found". But if I take the format of DOWNLOAD off, the data came back.
Any suggestion? Thanks!
The format statement does NOT go on the BLOB column. In fact, in your select statement for the report, you do not even need to select the BLOB column. You only have to identify the BLOB within the format statement.
So based on the data you supplied, your select statement for the report should probably be:
SELECT ID, NAME, DESCRIPTION, DBMS_LOB.GETLENGTH("CONTENTS") "CONTENTS"
WHERE ID = 100;
Then, put the FORMAT statement on the ID column of your report.
where: DOCUMENT = Table Name,
CONTENTS = The BLOB column
ID = The primary key for the DOCUMENT table.
That should be all the information you need to make the download work.