Re: Sending mail from procedures?

From: Win Ker <Winker11_at_hotmail.com>
Date: Sun, 10 Oct 1999 14:37:56 GMT
Message-ID: <3800A4C0.EE855869_at_hotmail.com>


I'd love to see it as well...please forward a copy to winker11_at_hotmail.com.

Thanks!

Allen Hayden wrote:

> > Does anyone know if it is possible to send an email message from a stored
> > procedure? Is there any package that can do this?
> >
>
> David,
>
> Actually, a few dba/developers have been testing an SMTP mail
> utility I wrote that will work with Oracle 7.3 & 8 which can be
> called from a stored procedure. For example,
>
> hwmail.send_email(v_from in varchar2,
> v_organization in varchar2,
> v_internal in varchar2,
> v_to in varchar2,
> v_cc in varchar2,
> v_subject in varchar2,
> v_body in varchar2,
> v_response out varchar2);
>
> Just let me know and I'll shoot you the details.
>
> Allen
>
> ---------------------------------------------------------------
> Hayden Worthington, Inc. Oracle Performance Group
> 5696 Peachtree Parkway http://hayden.home.mindspring.com
> Atlanta, Georgia 30092 Free White Papers, Scripts, etc.
Received on Sun Oct 10 1999 - 16:37:56 CEST

Original text of this message