My Oracle Support Banner

Apex Mails Stuck with Error: ORA-06502 "PL/SQL: numeric or value error: character string buffer too small" (Doc ID 3021551.1)

Last updated on JUNE 04, 2024

Applies to:

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

Symptoms

On : APEX 22.2 version, Administration

When attempting to send emails from APEX
the following error occurs.

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

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Use the APEX application that would send email
2. The emails do not arrive
3. Check he APEX email Queue



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
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.