OCI Email Delivery Service - multiple recipients

APEXUTIL Blog · 4 years ago · 128 views

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 => '[email protected], [email protected] some stupid text [email protected]; [email protected]') as cleaned_addresses; from dual CLEANED_ADDRESSES -- [email protected],[email protected],[email protected],[email protected] 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