5 Replies Latest reply: Sep 11, 2013 3: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

      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