How to Send Emails with Attachments in Oracle APEX
In this video we will take a look at how to build a simple application that:
Create a simple end user form in Oracle APEX
Pull a designers HTML email template from github
Substitute APEX items into the HTML template for preview functionality
Leverage APEX_MAIL API to send a email via OCI Notifications
Leverage APEX_MAIL API to pull a .pdf from a BLOB column in the database and attach to the email
This video leverages Oracle Cloud inside a free tier account. It was developed on top of Oracle Autonomous Database (ATP 21c) leveraging APEX 21.1.7.
Before attempting this build in your environment you will need to setup APEX with OCI Notifications.
https://blogs.oracle.com/apex/post/se...
All Code In this video can be found at:
https://github.com/chipbaber/apex_email
#oci #apex #freetier #oracle #oracledevelopers #ocinotifications