Re: Automatic Email

From: <georg.heiss_at_gmx.de>
Date: 2000/07/25
Message-ID: <8lk03s$es4$1@nnrp1.deja.com>#1/1

The following code example illustrates how the SMTP package might be used by an
application to send email. The application connects to an SMTP server at port 25
and sends a simple text message.
PROCEDURE send_mail (sender IN VARCHAR2, recipient IN VARCHAR2,
message IN VARCHAR2)
IS
mailhost VARCHAR2(30) := 'mailhost.mydomain.com'; mail_conn utl_smtp.connection;
BEGIN
mail_conn := utl_smtp.open_connection(mailhost, 25);

utl_smtp.helo(mail_conn, mailhost);
utl_smtp.mail(mail_conn, sender);
utl_smtp.rcpt(mail_conn, recipient);
utl_smtp.data(mail_conn, message);
utl_smtp.quit(mail_conn);

EXCEPTION
WHEN OTHERS THEN
-- Handle the error
END; In article <17599f0b.10786ac8_at_usw-ex0106-044.remarq.com>,   Joker <mike_murphyNOmiSPAM_at_eis.ca.invalid> wrote:
> Looking for a solution for creating email messages programatically
> using Oracle. This will be used in a Web enabled DB and iFS is not a
> likely option!
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion
 Network *
> The fastest and easiest way to search and participate in Usenet -
 Free!
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jul 25 2000 - 00:00:00 CDT