Save Interactive Grid Fails With ORA-06502 (Doc ID 2743876.1)

Last updated on JANUARY 13, 2021

Applies to:

Symptoms

On : APEX 20.2 version, Flow Builder

When attempting to edit and save  save an Interactive Report (IR) or Interactive Grid (IG) after changing a row with a varchar2 column with data close to 4000 bytes (like 3990 or higher)
the following error occurs.

ERROR
-----------------------
ORA-06502: PL/SQL: numeric or value error: character string buffer too small


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1 Create an IG or IR based on a table with a varchar2 column where data has been entered close to the 4000 limit -- this column is read only in the report
2 Display the report and try to change other columns (any simple one character column per example)  -- notice that you have not added more data to the varchar2 almost full
3. Try to save the Row, get the error

WHAT IT WORKING
------------------
Other rows in the same IG are able to edit and change values and save IF the varchar2 column has less characters on it (like 3800 per example)

Changes

 Created a new report page based on a table this table with varchar2 column where some rows fill in the capacity of the column

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.