My Oracle Support Banner

APEX Login Fails with Error: ORA-06502: PL/SQL: Numeric or Value Error (Doc ID 3033135.1)

Last updated on JULY 17, 2024

Applies to:

Oracle Application Express (APEX) - Version 22.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to login to APEX (either back-end or front-end), the following error occurs:

Error processing request
Contact your application administrator. Details about this incident are available via debug id "<numbers>"

Reviewing that debug message as mentioned in Doc ID 2601685.1 the following error can be seen:

SQL error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APEX_240100.WWV_FLOW_CGI", line 293
ORA-06512: at "APEX_240100.WWV_FLOW_SECURITY", line 2916
ORA-06512: at "APEX_240100.WWV_FLOW_SECURITY", line 2929
ORA-06512: at "APEX_240100.WWV_FLOW_SECURITY", line 2994
ORA-06512: at "APEX_240100.WWV_FLOW_AUTHENTICATION", line 639
ORA-06512: at "APEX_240100.WWV_FLOW_AUTHENTICATION", line 2058

Changes

This issue has been reported after upgrading APEX version but could be other causes as well.

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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