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