Re: Mail from Oracle!!
Date: Thu, 07 May 1998 21:03:29 GMT
Message-ID: <6it7j1$rjc$1_at_nnrp1.dejanews.com>
In article <01bd7956$cfeff5c0$34e800c8_at_511_0324>,
"Manolo's" <friend_inv_at_hotmail.com> wrote:
>
> Hello!!
>
> I need to send an e-mail trough a store procedure or a job running on the
> Database.
>
> I have'nt Oracle Office and the platform is Solaris.
>
> I will apreciatte any idea..
>
> mjerez_at_hotmail.com
>
One way:
If you have the Web/Application server you can do what I did. Write a C
program using MAPI to send an email. Move this into an Oracle Web
(Application) Server Cartridge that is called from the PL/SQL agent (aka a
stored procedure) as part of a web page.
2nd Way
If I was using Oracle 8 I fairly sure the same C code could be called as an
external procedure to send the mail from a PL?SQL stored procedure.
Details are in the Oracle Manuals for the Web Server and/or Oracle 8 and the MAPI info I needed I found on Microsoft Online
Hope this helps
kevin_n_at_rte-asset.com
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu May 07 1998 - 23:03:29 CEST