I want to send an email from the "apex_send.mail" package.
To do this, I wrote the process below which is executed at the click of a button:
DECLARE
l_body VARCHAR2(200);
l_id NUMBER;
BEGIN
l_body := 'This is a text of sending mail with the APEX_MAIL
package. Thank you' ;
l_id := apex_mail.send(
p_to => 'xxxx@yahoo.fr',
p_from => 'xxxx@yahoo.fr',
p_body => l_body,
p_subj => 'APEX_MAIL Package - Text message');
END;
The process works correctly, but when I go to the Administration section of Apex precisely at the level of Manage Instance -> Mail Queue, an error message appears "ORA-29278: SMTP transient error: 421 Service not available".
I have done research on the Internet to be able to solve this problem but without success so far.
Please, someone could help me, because I have been stuck for several days on this problem.
I use Apex 19.2, Oracle 12C as the database and Windows 10 professional.
Thank you in advance.