Hallo, working on Oracle Linux 6 and XE 18c Database. It is a small private environment.
I like to send emails from PLSQL. Either via apex_mail or utl_mail.
What do I need to setup to achieve this?
I am able to send mails from Linux according to this post https://www.support.dbagenesis.com/post/send-email-from-oracle-linux-server
So I set up postfix and am able to send emails via Linux.
But I do not know what to do if I want to send mails via PLSQL with the above mentioned functions. I'm sure there needs to be some more configuration done. But I can't figure it out by myself.
Any help appreciated. Step-by-step instructions most welcome.
Regards, Peter
To send an email from an Oracle Application Express application, utilise the APEX MAIL package. This package is based on the UTL SMTP package provided by Oracle. Because of this dependency, APEX MAIL requires the UTL SMTP package to be installed and running.
Please visit link mentioned below for further details:
https://docs.oracle.com/database/121/AEAPI/apex_mail.htm#BABIJAAD