Re: Send e-mail from stored-procedure

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

you can try this:

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 <8l02it$oje$1_at_newsfeed.smartt.com>,   "Sunny" <sunnyb_at_vendtek.bc.ca> wrote:
> Hi Seno
>
> I am also looking for something like this where i can send email from
 a
> stored procedure. I know you can use an external stored procedure
 written in
> either Java or C/C++ to do it, but i am looking for something right in
> Oracle stored procedures to do it.
> So Seno if you find anything please let me know too and if i find
 something
> i will do too. Thanks
>
> Sunny Bagri
> Oracle Developer
> <senohp_at_my-deja.com> wrote in message news:8ksdg3
 $tet$1_at_nnrp1.deja.com...
> > Hi,
> >
> > I need a stored procedure for sending an email for alerting users on
> > any specific criteria. I plan to make this procedure to recuring
> > utilizing DBMS_JOB.
> >
> > My environtment is an Oracle 8.05 server on NT4.
> >
> > Are there anyone can help me ?
> >
> > Thanks in advance
> >
> >
> > Seno Hardijanto
> >
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

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