Oracle Application Express (MOSC)

MOSC Banner

ORA-06502 WHEN CALL APEX_MAIL

edited Jul 31, 2025 1:46PM in Oracle Application Express (MOSC) Question

We have an APEX instance with 23.2.6 version. However receiving the following error documented as bug and resolved with Patch Set Bundle for Oracle APEX 23.1

Patch Set Bundle for Oracle APEX 23.1 (35283657)
35381042 -ORA-06502 WHEN THE APEX_MAIL PACKAGE IS EXECUTED (WORK AROUND PL/SQL BUG 35072180)

Has anyone have any idea why we are still getting this error even the current version is higher than the suggested patch version? I have tested all the possibilities about data length of the paramater, no luck.

Code snipped :

DECLARE
l_from VARCHAR2(4000); —tried 200 too no luck
l_to VARCHAR2(4000); —tried 200 too no luck
l_subject VARCHAR2(255);

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center