Tuesday, May 26, 2009

You can send emails from an Oracle database via UTL_SMTP

You can send emails from an Oracle database via UTL_SMTP.

Here's a simple example:

declare
mail_conn UTL_SMTP.CONNECTION;
BEGIN
mail_conn := utl_smtp.open_connection('yourmailserver.com',25);
utl_smtp.helo(mail_conn, 'yourmailserver.com');
utl_smtp.mail(mail_conn, 'youremail@yourdomain.com');
utl_smtp.rcpt(mail_conn, 'youremail@yourdomain.com');
utl_smtp.data(mail_conn, 'hello');
utl_smtp.quit(mail_conn);
END;
/

No comments:

Post a Comment