To send mails in our projects most often we use Oracle Cloud Email Delivery Service. From official OCI Email Delivery description you can find:
"Oracle Cloud Infrastructure Email Delivery is an email sending service that provides a fast and reliable managed solution
for sending high-volume emails that need to reach your recipients' inbox. Email Delivery provides the tools necessary to send
application-generated email for mission-critical communications such as receipts, fraud detection alerts, multi-factor identity
verification, and password resets."
... sounds good ? yes and works good as well ; )
Buuuut two weeks ago I found some issue according send mail to multiple recipients. All multiple recipients mails stucked !
After few minutes of investigation I found a reason. OCI Email Delivery Service accepts only coma as a recipients separator without any other char.
To fix it I prepared small function which parses string containing email addresses and returns them with proper format. If you have the same problem you can use it as I did below:
create or replace function clean_email_addresses(p_address_string in varchar2)
return varchar2
is
lt_mails apex_t_varchar2;
begin
lt_mails:=apex_string_util.find_email_addresses(p_address_string);
return apex_string.join(lt_mails,',');
end;
/
select clean_email_addresses
(p_address_string => 'some_user@somewhere.com,
othermail@anddomain.com some stupid text
oneothermail@domain.com; alsonemail@domain.com')
as cleaned_addresses;
from dual
CLEANED_ADDRESSES --
some_user@somewhere.com,othermail@anddomain.com,oneothermail@domain.com,alsonemail@domain.com
sql>
BTW
I tried to find official information how to prepare multiple recipient to use with OCI Email Delivery but I found nothing, maybe somebody from Oracle will read this post and add some details to doc.
Subscribe
