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.