Skip to main content

OCI Email Delivery Service - multiple recipients

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.

Comments

Popular posts from this blog

ORACLE APEX with MySQL !

About 10 years ago I tried to build APEX application on MS SQLServer. It was possible but performance was not satisfactory. (You can read this post here) ... Today I will describe how to use APEX with MySQL. Obviusly I don't think it is good idea to build APEX app only on MySQL. It can be used as part of Hybryd solution (Oracle + MySQL or Postrgres). My description covers integration with MySQL. As a result will be APEX application with Interactive Report and CRUD form based on MySQL data. Description contains two parts: First part is a MySQL site, Second part is a APEX application part Prerequisites: Oracle 11g+ APEX 18.1+ MySQL/Postgres RestSQL I. MySQL Part 1. MySQL contains simple  apexdb database with one apexutil table. 2. To use this database install RestSQL. What is RestSQL? RestSQL is an open-source, ultra-lightweight data access layer for HTTP clients. RestSQL is a persistence framework or engine in the middle tier of a classic three tier archi

TWO-Factor Authentication with APEX application.

Two-factor authentication means that you must have two factors, to access your account. The first factor is something you know, like your login and password combination. The second is something you have, like a mobile device with a security app installed. That second factor — the mobile device with a security app — adds an extra layer of protection to your account. Even if hackers steal your password, they can’t log in, because they don't have your mobile device. Try 2FA on our SANDBOX environment! It is the most popular 2FA option based on Times-based One-Time Password (TOTP) alghoritm described in RFC 6238 and RFC 4226. TOTP is supported by Google Authenticator, Microsoft Authenticator, Authy 2-Factor Authentication and many other mobile apps. The most popular online services like Facebook, Google, Twitter use TOTP to protect user's accounts. TOTP is a standard algorithm based on cryptographic hash method SHA-1. SHA-1 algorithm's implementation is available sin

How to return json with null value using apex_json.write(ref_cursor)

Few days ago I had to develop dynamic query json export module. As a sandbox I prepared PLSQL block: DECLARE c sys_refcursor; l_sql varchar2(4000) := 'select null as "col1", 100 as "col2" from dual union all select 200 as "col1", null as "col2" from dual'; l_file clob; BEGIN open c for l_sql; apex_json.initialize_clob_output; apex_json.open_object; apex_json.write('rowset', c); apex_json.close_object; l_file := apex_json.get_clob_output; apex_json.free_output; DBMS_OUTPUT.PUT_line(l_file); END; { "rowset": [{ "col2": 100 }, { "col1": 200 } ] } As you can see above PLSQL code doesn't return null value pairs : ( apex_json.write(p_name IN VARCHAR2, p_cursor IN OUT NOCOPY sys_refcursor) procedure Signature 14 doesn't support null. How to fix it... ? APEX API provides apex_js