Sending mail from APEX with authentication

DECLARE
l_connection utl_smtp.connection;
BEGIN
l_connection := utl_smtp.open_connection(host => 'mailhost.xyz'
,port => 25
);
utl_smtp.ehlo(l_connection
,'mailhost.xyz'
);
utl_smtp.auth(l_connection
,'testuser@mailhost.xyz'
,'mypassword'
);
APEX_MAIL.SEND(p_to => 'testuser@mailhost.xyz'
,p_from => 'testuser@mailhost.xyz'
,p_subj => 'test'
,p_body => 'test'
);
END;

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to create an Oracle Wallet?

In order to secure your domain you need to the following:  We complete all necessary...

Can I use my domain name with Apex?

Absolutely, you will have full ftp/sftp access to the server as well.

Do you support SSL/https with APEX Hosting package?

Yes, we do. We can create temporary ssl certificate and when you are ready for a production you...

How do I send e-mail messages from PL/SQL?

Please follow this greate example: below: (http://www.orafaq.com/scripts/plsql/smtp.txt) rem...

How can I access APEX if I don't have domain name yet?

You can access APEX and develop your application even if you don't have domain name yet....