Home » SQL & PL/SQL » SQL & PL/SQL » ORA-29279: SMTP permanent error (split from hijacked topic)
ORA-29279: SMTP permanent error (split from hijacked topic) [message #681736] Sat, 22 August 2020 09:24 Go to next message
samsam
Messages: 1
Registered: August 2020
Junior Member
can anybody please help me out,i am facing the below issue while trying to send mail to multiple recipients.
EXEC MY_PROCEDURE;
[Error] Execution (1: 1): ORA-29279: SMTP permanent error: 503 5.5.2 Need rcpt command
ORA-06512: at "SYS.UTL_SMTP", line 57
ORA-06512: at "SYS.UTL_SMTP", line 142
ORA-06512: at "SYS.UTL_SMTP", line 518
ORA-06512: at line 1
Re: E-Mail sending issue from Oracle Database [message #681737 is a reply to message #681736] Sat, 22 August 2020 11:06 Go to previous messageGo to next message
Michel Cadot
Messages: 67851
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

Also always post your Oracle version, with 4 decimals (query v$version), as often solution depends on it.

Your code is not correct.
See https://en.wikipedia.org/wiki/List_of_SMTP_server_return_codes



Re: E-Mail sending issue from Oracle Database [message #681738 is a reply to message #681736] Sat, 22 August 2020 13:28 Go to previous message
EdStevens
Messages: 1317
Registered: September 2013
Senior Member
In addition to Michel's comments, you really should start your own thread, rather than hijacking and reviving someone else's 6-year old thread.
Previous Topic: Select and load CLOB column data into another table
Next Topic: Find out how long is the field or column
Goto Forum:
  


Current Time: Tue May 18 00:39:09 CDT 2021