APEX Tabular Forms ORA-06502 / ORA-0000 Errors
(Doc ID 2273581.1)
Last updated on FEBRUARY 18, 2021
Applies to:Oracle Application Express (APEX) - Version 5.1.1.00.08 and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Tabular forms getting ORA-0000 intermittently.
Temporary fix is to remove one of the fields.
Have a very small application that is using tabular forms to display and edit data. This small app did work fine initially, but ORA-0000 errors started to show up once users clicked on buttons that should navigate to a page with a tabular form.
Hiding one of the columns on the tabular form (Uncheck "Show"), allows the form to work okay for a while, then ORA-0000 error is thrown again. Have already hidden 3 columns from report, only 6 more columns do remain.
Here is another error that users are getting when Apex is generating tabular forms:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
That is also addressed if one column is hidden. Then the page (tabular report) generates successfully again.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document