Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

UTL_SMTP: error 421

70097Jan 8 2003 — edited Jan 8 2003
I have a PL/SQL block that repeatedly calls UTL_SMTP in a loop, basically e-mailing a group of addressees. The first send works fine (the message arriving successfully), but on the second and subsequent calls error 421 is raised by UTL_SMTP.HELO . My first and only guess was that messages were being sent too quickly for the mail server to process, so I inserted a 'sleep' of about five seconds between messages, but that didn't work.
I am using CLOSE_DATA and QUIT at the end of each iteration.

Many thanks,
Andrew Hunter
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 5 2003
Added on Jan 8 2003
6 comments
433 views