hi Experts,
I have an Interactive Report and when trying to Download it as an Excel I am getting the following error "ORA-06502: PL/SQL: numeric or value error: character string buffer too small"
Excel 1st cell = <div id="R28232029002115240187_data_panel" class="a-IRR-reportView"><div class="a-Form-error">ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Now, giving the error I was looking into the latest added columns to this report ( before was working just fine ). Couldn't find any issues with the query, runs just fine in the SQL Commands and also the results download in Excel ( CSV ) just fine.
However, when looking into the APEX, and after many tries, I've discovered that when the Interative Report has more than 26 columns crashes with the error I've mentioned, i.e. = ORA-06502: PL/SQL: numeric or value error: character string buffer too small.
Any 26 columns I am selecting or less, will download the Report just fine in the Excel.
( using APEX 18)
Any ideas ?
Thank you
Edi