Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Image column in an interactive report (APEX 4.0)

456939Jul 13 2010 — edited Sep 22 2011
Hi,
I have added a new blob column containing images to an interactive report, but get the following error:-

ORA-06502: PL/SQL: numeric or value error: character to number conversion error

If the "IMAGE" column is removed from the report using the "actions:select column" control, the report is ok.

The column contains the following settings in the "BLOB Download Format Mask":-

IMAGE:WINEDETAILS:IMAGE:WINE_ID::MIMETYPE:FILENAME:::inline:Download

Have I missed something?

Regards
Tim
This post has been answered by sbkenned-Oracle on Jul 13 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 20 2011
Added on Jul 13 2010
23 comments
11,209 views