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 brukere syntes dette svaret var til hjelp
Var dette svaret til hjelp?

Relaterte artikler

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....