Hello everyone,
Here is my APEX version : 22.1.0
I have a table containing a blob column, which the schema is :
FILENAME
MIME_TYPE
UPL_DATE
FK (A FOREIGH KEY)
DATA (BLOB COLUMN)
I use an interactive report region. Its SQL request is :
SELECT
FILENAME AS "NOM",
MIME_TYPE AS "TYPE_MIME",
TO_CHAR(UPL_DATE, 'DD/MM/YYYY HH24:MI:SS') AS "UPL_DATE_COMPLETE",
DATA AS "DATA"
FROM
ATT
WHERE
A.FK = :PX_FK
ORDER BY
UPL_DATE DESC
So in the column part of the interactive report, my data column is displayed.
I set it like this :
IDENTIFICATION, TYPE : Download BLOB
BLOB ATTRIBUTES, TABLE NAME : ATT
BLOB ATTRIBUTES, BLOB COLUMN : DATA
BLOB ATTRIBUTES, PRIMARY KEY : ROWID
BLOB ATTRIBUTES, MIME TYPE : MIME_TYPE
BLOB ATTRIBUTES, FILENAME COLUMN : FILENAME
However, when I display the interactive report, I get ORA-01403:no data found.
What did I do wrong ? :D