This discussion is archived
5 Replies Latest reply: Sep 11, 2013 1:11 PM by bondurs Branched from an earlier discussion. RSS

Re: ERROR: ORA-06502: PL/SQL: numeric or value error: character to number conve

bondurs Newbie
Currently Being Moderated

Greetings all:

 

I'm using APEX 4.2.1.00.08.  I am having the exact same problem that 838626 was having in this year-old abandoned forum thread that I tried to resurrect and hijack.  I have a classic report where one of the columns is a BLOB column.  I am using the following format string in that column

 

DOWNLOAD:V_ENV_SITE_ASMT_DOC;ASMT_DOC_TXT:ASMT_DOC_ID::ASMT_DOC_CNTNT_TYP_TXT:ASMT_DOC_FILE_NME:::Attachment:Download

 

The report compile OK, but when I render the page, I get the ORA-06502 error, same as 838626 did.

 

Has anyone else experienced this?  Come up with a solution?

 

Thanks,

Stan