ORA-06502: PL/SQL: numeric or value error: character string buffer too small error in oracle apex report
Some time you may have come across "ORA-06502: PL/SQL: numeric or value error: character string buffer too small " error in an interactive report or other reports. It may look like an issue due to column limit exceed, but the main reason may be it reached upper limit of VARCHAR2(32K) which is used for internal packages.
As per "Component Limits" section of Oracle apex documentation (18.2) , the limit for interactive report is 999 rows per column heading filter (if no custom LOV is specified in the column attributes).
Solution:
Adjust the number of columns in the region source (SQL Query) so that it is less than about 200 columns or until no error occurs.
Ref: https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=276192905980555&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&id=2331775.1&_afrWindowMode=0&_adf.ctrl-state=vrt1khxdx_4
As per "Component Limits" section of Oracle apex documentation (18.2) , the limit for interactive report is 999 rows per column heading filter (if no custom LOV is specified in the column attributes).
Solution:
Adjust the number of columns in the region source (SQL Query) so that it is less than about 200 columns or until no error occurs.
Ref: https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=276192905980555&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&id=2331775.1&_afrWindowMode=0&_adf.ctrl-state=vrt1khxdx_4
Comments
Post a Comment