Re: Sending mail from a SP

From: a1 <thor_at_echidna.net>
Date: Mon, 11 Oct 1999 22:31:28 GMT
Message-ID: <4ztM3.1181$AL3.7148788@bunson.tor.sfl.net>

DBMS_MAIL only interfaces to Oracle's InterOffice, If you have, and if you can get it.

You can use the SUN supplied JavaMail packages and wrapper them in PL/SQL if you are on Oracle 8.1.5
Or
You can create a dbms_pipe application and have the external listener use sendmail to send your message.

Both are pretty quick solutions

Thor HW
Xuequn Xu <xux_at_informa.bio.caltech.edu> wrote in message news:7tosr8$k3b_at_gap.cco.caltech.edu...
> If you went through Oracle's PL/SQL training material, it says that there
> is a package called DBMS_MAIL. But I cannot find it... (I happened to have
> the same question as you do).
>
> Robert Xu
>
> marasoft (marasoft_at_home.com) wrote:
> : Does anyone know if it is possible to send an email message from a
stored
> : procedure (PL/SQL)? Is there any package that can do this?
>
> : Thank's
> : David
>
>
Received on Mon Oct 11 1999 - 17:31:28 CDT