Here the steps to use SMTP Outlook 365 as email outbond from oracle APEX
- Setup SMTP outlook 365 relay register your APEX host and get the smtp server name and port. how to to it check this youtube
- Create oracle wallet on DBaaS/DB to *.outlook.com
- Set Instance Setting > Email values on Workspace Internal
- Test it using apex_email
procedure send_email_test(
p_from varchar2 default 'info@yourdomain.com'
, p_to varchar2
, p_subject varchar2 default 'Email test'
)
as
l_body clob;
begin
l_body := 'Thank you for your interest in the APEX_MAIL package.'||utl_tcp.crlf;
l_body := l_body ||' Sincerely,'||utl_tcp.crlf;
l_body := l_body ||' The APEX Dev Team'||utl_tcp.crlf;
apex_mail.send(
p_to => p_to, -- change to your email address
p_from => p_from, -- change to a real senders email address
p_body => l_body,
p_subj => p_subject
);
APEX_MAIL.PUSH_QUEUE;
end send_email_test;
Thats it and good luck :D
Tidak ada komentar :
Posting Komentar