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!

Clasic Report with Download BLOB column getting ORA-06502: PL/SQL: numeric or value error: characte

Andrei_Iosub-OracleMar 20 2017 — edited Mar 20 2017

Hello,

I have a table with a BLOB column and I am trying to create a report with a download link.

These are the properties of the report column intended for download.

pastedImage_0.png

In the page with the report I'm getting:

report error:

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

from Debug:

Exception in "Report 1":

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

Backtrace: ORA-06512: at "APEX_050100.WWV_RENDER_REPORT3", line 7965

I've replicated it on apex.oracle.com.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 17 2017
Added on Mar 20 2017
1 comment
3,548 views