Forum Stats

  • 3,837,666 Users
  • 2,262,282 Discussions


APEX 4.2 Report Exports and Column Limitations

Larry R
Larry R Member Posts: 10
edited Mar 26, 2020 1:39PM in APEX Discussions

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.

Best Answer