I have an APEX 4.2 application where we want to give users the ability to download a very large report into Excel. The report has 325 columns and over 20k rows. I've tried both Interactive and Classic with the following results:
When creating a Classic Report with all of the columns, an error is generated = ORA-01461: can bind a LONG value only for insert into a LONG column.
When creating an Interactive Report with all of the columns, an error is generated = ORA-06502: PL/SQL: numeric or value error: character string buffer too small.
I do not need to display the report on the page, but require only a way to download the results of the report's query to an Excel file, much like the reports' built-in Download feature. I would prefer, in fact, to not display the oversized query results.