ORA-29261: Bad Argument In APEX_MAIL.SEND Function
(Doc ID 1583393.1)
Last updated on SEPTEMBER 10, 2021
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterOracle Application Express (APEX) - Version 4.2.0.00.27 and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
On : 4.2.0.00.27 version, Administration
When attempting to sent an email from any apex application, the following errors occur:
ERROR
-----------------------
ORA-29261: bad argument
and after several similar errors in the apex mail queue the follow error is also seen
ORA-30678: too many open connections
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Send email using inside apex (sql*workshop or application) code like
DECLARE
l_id NUMBER;
l_to varchar(90);
BEGIN
SELECT '<username@mailhost1.com>'
INTO l_to
FROM dual;
l_id := APEX_MAIL.SEND(
p_to => l_to ,
p_from => '<username@mailhost2.com>',
p_subj => 'Test Appointment Notice',
p_body => 'You have a new appointment:');
APEX_MAIL.push_queue;
END;
Where <username@mailhost1.com> and <username@mailhost2.com> represents a valid email address.
2. The email is not sent but showed in the email queue with error
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 |