Re: Sending mail from procedures?

> 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.