Loading...

Wednesday, May 23, 2007

ORA-29279: SMTP permanent error: 501 Bad address syntax

While checking if procedure APEX_MAIL.SEND could send out a message to multiple users and being too lazy to open up the on-line help window and check what the documentation says, i made an attempt for sending a message to multiple recipients as follows:

begin
apex_mail.send(
p_to => 'first@somedomain.com;second@somedomain.com',
p_from => 'apex@someaddress.com',
p_body => 'test message'
);
apex_mail.push_queue;
end;

But looking at view APEX_MAIL_QUEUE, i saw the message below in column MAIL_SEND_ERROR

ORA-29279: SMTP permanent error: 501 Bad address syntax

This is caused by the semicolon (;) used for separating the addresses.
Use commas (,) instead.

To delete undeliverable messages from APEX_MAIL_QUEUE, just execute:

delete from APEX_MAIL_QUEUE
where MAIL_SEND_ERROR is not null;


See message translations for ORA-29279 and search additional resources.



ORA-29279: Errore permanente SMTP:
ORA-29279: error permanente de SMTP:
ORA-29279: error permanent de SMTP:
ORA-29279: erreur permanente SMTP :
ORA-29279: Permanenter SMTP-Fehler:
ORA-29279: μόνιμο σφάλμα SMTP:
ORA-29279: permanent SMTP-fejl:
ORA-29279: Permanent SMTP-fel:
ORA-29279: permanent SMTP-feil:
ORA-29279: pysyvä SMTP-virhe:
ORA-29279: SMTP állandó hiba:
ORA-29279: eroare permanentă SMTP:
ORA-29279: Permanente SMTP-fout:
ORA-29279: erro permanente de SMTP:
ORA-29279: erro permanente de SMTP:
ORA-29279: Постоянная ошибка SMTP:
ORA-29279: Permanentní chyba SMTP:
ORA-29279: trvalá chyba SMTP:
ORA-29279: trwały błąd SMTP:
ORA-29279: SMTP kalıcı hatası:

4 comments:

Marcel said...

HI , I am trying to use the apex email in one client , I can send the email for all emails from the webmail , but when I send email to uol, gmail or any other , all email did not send.

email server :mail.xpto.sp.gov.br
ex. from :marcel@xpto.com
to :marcio@xpto.com
OK
from :marcel@xpto.com
to :marcio@gmail.com

Byte64 said...

Marcel,
did you try inspecting view apex_mail_log?

Waigwa Gichuhi said...

Hi! I am not sure if the error message am getting is related to the one you've posted. This is the Error: - ORA-29279: SMTP permanent error: 550 Relaying denied.

After much googling and following what uve posted, am stil stuck. I am trying to send an email by calling a database procedure. Could the problem be solely on the mailServer?

Byte64 said...

the problem IS on the mail server, the IP address of the database server is not authorized to "talk" to the smtp server.
Although I am not an expert on mail servers, I'd say this is normal nowadays with all those spammers around.
If you are the sysadmin of the mail server you need to configure it in order to accept requests from the DB server IP address or you need to talk to your sysadmin and explain your problem.

Regards
Flavio

yes you can!

Two great ways to help us out with a minimal effort. Click on the Google Plus +1 button above or...
We appreciate your support!

latest articles