Error with interactive report and display of blob in report
Hello,
I have an interactive report. I have been asked to include a link to be able to download the blob if so required. I added the blob column to the IR since it is already a column in my table. In the settings for this BLOB column I modified the Number/Date Format to use then BLOB Download Format Mask and then set up the values accordingly. So my number/data format for this column now looks like this..
DOWNLOAD:EMS_FSA_DOCUMENTS:SSR_ATTACHMENT:FSA_DOC_ID::SSR_MIMETYPE:SSR_FILENAME:SSR_LAST_UPDATE_DATE::inline:Download
Unfortunately, after setting this if I go back to run the report I get the error .. ORA-06502: PL/SQL: numeric or value error: character to number conversion error
I cannot figure out why I am receiving this error, since on the data entry form I have created, I have the exact same fields being referenced for the definition of the BLOB field and it seems to work just fine. So why I'm getting this error on the IR, I'm just not quite sure.
Does anyone have any ideas??
Thx