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.
In the page with the report I'm getting:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
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.
I've added to my query :
length(xps_collection.blob_content) as blob_len
After changing the type for this column (BLOB_LEN) to "Download BLOB" and setting the BLOB Attributes it seems to be working!
Note: trying to set Appearance > Download text to #FILENAME# so that I get the name of the file in the link column does not work. Help mentions: