Home » SQL & PL/SQL » SQL & PL/SQL » Multiple Recipients in SMTP
Multiple Recipients in SMTP [message #389352] Sun, 01 March 2009 06:31 Go to next message
Messages: 145
Registered: January 2008
Senior Member
Dear all,

I am getting an error while sending to multiple recipients.
The error message is "ORA-29279: SMTP permanent error: 501 5.5.4"

Can anyone suggest how to send multiple recipients?


Re: How to send a mail from PL/sql [message #389353 is a reply to message #389352] Sun, 01 March 2009 07:29 Go to previous message
Messages: 3186
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
By sending multiple

utl_smtp.rcpt(mail_conn, recipient);

lines. You can only specify ONE recipient per RCPT statement, that's the way the SMTP protocol works.

Oh, and don't hijack three year old threads, start a new one with a new question. I split this one.

[Updated on: Sun, 01 March 2009 07:32]

Report message to a moderator

Previous Topic: Read from long field more then 4000 bytes to varchar (merged)
Next Topic: Single Row Subquery returns more than one row... Help with query
Goto Forum:

Current Time: Wed Oct 26 00:52:46 CDT 2016

Total time taken to generate the page: 0.26734 seconds