APEX Tabular Forms ORA-06502 / ORA-0000 Errors
Last updated on JULY 17, 2018
Applies to:Oracle Application Express (formerly HTML DB) - Version 5.1.1.00.08 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms