Re: Sending mail from procedures?

I'd love too... Please send me a copy to micadot_at_netcourrier.com

Thanks

--
Regards

Michel


Allen Hayden <hayden_at_mindspring.com> a écrit dans le message :
38009306.71F1D1B4_at_mindspring.com...


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