The table/view that you are using for the Interactive Report needs have the BLOB column for the actual image and another column that contains the size.
You will SELECT the size column, but, you will FORMAT it as a BLOB. (basically, it is point-click-choose column name, etc.-> APPLY CHANGES -> done)
example on apex.oracle.com: (name/passwd === demo/demo)
sql for the report:
select IMAGE_TABLE.IMG_ID as IMG_ID,
IMAGE_TABLE.IMAGE_NAME as IMAGE_NAME,
DBMS_LOb.getLength(image_thumbnail) as IMAGE
from IMAGE_TABLE IMAGE_TABLE
When do you get the error?
Double check that the PK column name is set correctly for the BLOB format.
Only other thing I can think of would be: You don't have an image in that column
add another column that checks if you have a NULL value
eg: decode( image_column, null, 'No Image', 'Image') as check_existence
Remove the BLOB format and look for images of length=0
Other than that, you'll have to reproduce the problem on apex.oracle.com (unless someone else has ran into this issue before)
the error displayed when i start the apex application, but only when i change the BLOB-IMAGE column to display the image instead of the length. If i only display the result of the select statement, i get no error.
Maybe there is a problem with the PK.. i have got an ID column, which i set as PK. This is my first time working with a DB and Apex, so maybe there is a high possibility, that i made a mistake.
If i hide the IMAGE column (the original size column), the table ist displayed in the application. If i change the format to DOWNLOAD, i get the same error message to.