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!

How to send a message to multiple recipients

User_RFKSXSep 17 2021

Hi,
I've tried to send a message to a single recipient by using
UTL_SMTP.rcpt(l_mail_conn, p_to);
where p_to can contain only a email address. In order to send a message to multiple recipients, the only possibility (as far as I know) is to call this routine multiple times, but is there another way to send the same message to multiple recipients all at once so as to allow every recipient to see the others instead of having multiple emails ?
Oracle version 10g
Thanks
Mark

Comments
Post Details
Added on Sep 17 2021
2 comments
1,812 views