PL/SQL (MOSC)

MOSC Banner

Sending emails to Multiple Recipients using UTL_SMTP

edited Dec 27, 2017 4:01AM in PL/SQL (MOSC) 17 commentsAnswered
I have a stored procedure created using the Oracle Note ID 744605.1 to send emails to Multiple Recipients using UTL_SMTP but its not working.
When did a test, it says Your e-mail was successfully sent but I am not getting any emails.
Sample Syntax,

EXEC send_mail('sender@domain.com', 'recipient1@domain.com, recipient2@domain.com, recipient3@domain.com', 'Subject of TEST EMAIL USING UTL_SMTP', 'Body of TEST EMAIL USING UTL_SMTP');
I also tried with one email recipient but still no email was generated. Not sure what was causing the problem. Any one using UTL_SMTP to send emails to multiple recipients, please advise.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center