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;
/
Tuesday, May 26, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment