APEX Tabular Forms ORA-06502 / ORA-0000 Errors (Doc ID 2273581.1)

Last updated on JUNE 05, 2017

Applies to:

Oracle Application Express (formerly HTML DB) - Version 5.1.1.00.08 and later
Information in this document applies to any platform.

Symptoms

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:

report error:
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.



Cause

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