"ORA-06502: PL/SQL: numeric or value error: character string buffer too small" While Rendering Page Item (Doc ID 2115688.1)

Last updated on SEPTEMBER 20, 2016

Applies to:

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

Symptoms

A particular page cannot be run and the following errors are raised:

Error on Page

Error during rendering of page item [item name]

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

Error from Page Debug

0.39011 0.00091 Logging exception: Sqlerrm: ORA-20987: APEX - Error during rendering of page item WDB QUERY. - ORA-06502: PL/SQL: numeric or value error: character string buffer too small Backtrace: ORA-06512: at "APEX_040200.WWV_FLOW_ERROR", line 630 ORA-06512: at "APEX_040200.WWV_FLOW_ERROR", line 911 ORA-06512: at "APEX_040200.WWV_FLOW_FORMS", line 1485 ORA-06512: at "APEX_040200.WWV_FLOW_DISP_PAGE_PLUGS", line 3772 ORA-06512: at "APEX_040200.WWV_FLOW_DISP_PAGE_PLUGS", line 4605

0.39100 - Logging exception in final_exception_handler: Sqlerrm: ORA-20987: APEX - Error during rendering of page item WDB QUERY. - ORA-06502: PL/SQL: numeric or value error: character string buffer too small Backtrace: ORA-06512: at "APEX_040200.WWV_FLOW_ERROR", line 861 ORA-06512: at "APEX_040200.WWV_FLOW_ERROR", line 896 ORA-06512: at "APEX_040200.WWV_FLOW_DISP_PAGE_PLUGS", line 3285 ORA-06512: at "APEX_040200.WWV_FLOW_PAGE", line 1788 ORA-06512: at "APEX_040200.WWV_FLOW_PAGE", line 1958 ORA-06512: at "APEX_040200.WWV_FLOW", line 5418

 

Changes

 New installation of, or upgrade to, APEX 4.2.X

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