Hello,
I am using APEX 4.2 . I need to display a cross tab , with approx. 300 lines and 270 columns.
The rows represent some MATERIAL (M0,M1,...) and each one is made of some quantity of CHEMICAL , the columns (C0,C1,C2, etc.).
In SQL I create a PIVOT which returns my data in a correct way, and the display works fine (see below) and we can scroll horizontally, vertically.
In fact it works fine as long as define with Actions-> Select Columns only 199 columns (to be precise 204 columns including the Material ones).
If I try to add more I get the following error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Of course that's many columns, but my customers would like this way in order to replace their current Excel "application + database" tool ;-)
This report is display only, I will add a link to a master-detail edit page.
Thanks for any help you can provide. (And currently we must stay with 4.2, the upgrade to 5.0 is planned in 8 months.)