ORA-06502 WHEN CALL APEX_MAIL
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);