Re: How to send e-mail from Oracle
Date: 1996/10/23
Message-ID: <54llbh$4pe_at_lily.redrose.net>#1/1
Or save yourself the money and the aggravation of dealing with Oracle Applications by doing the following:
- Create a table that will store your email message. Your trigger an automatically update this table.
- Create an OS script that will check this table periodically and send the email message that is in the table.
Your table could contain all the info (username, message, etc.) needed. If you need real-time response, you could have the trigger on your mail table send a message through a pipe telling your waiting OS program that the table was updated.
In article <846047174.2565snx_at_aleytys.pc.my>,
philip_at_aleytys.pc.my (Philip Chee) wrote:
>In article <54jr0l$s50_at_ms.mimos.my> mariah_at_ms.mimos.my writes:
>
>>Suppose I have this scenario. A warehouse stores items belonging to
clients.
>>The client will send e-mail to the warehouse manager whenever there are
orders
>>from customer for a particular item. The warehouse manager will run
>>SQL*Loader to process the order causing an Oracle trigger to fire which in
>>turn updates the database. After awhile the items in the warehouse will be
>>depleted. This is when the warehouse manager has to send e-mail to the
>>clients telling them about the status of their storage. I want the e-mail
to
>>be send automatically during the update of the database, i.e while running
>>the trigger. That means I have to do some coding to call a host function
>>from within the trigger. How do I do that? I'm running Oracle 7.2 on
>>Solaris 2.3. Any help is much appreciated. Thank you.
>
>Have you looked at Oracle Alerts from Oracle Corp? This may be what you
>need without coding extensive triggers.
>
>Philip
>---=====================================================================---
> Philip Chee: Tasek Cement Berhad, P.O.Box 254, 30908 Ipoh, MALAYSIA
> e-mail: philip_at_aleytys.pc.my Voice:+60-5-545-1011 Fax:+60-5-547-3932
> Guard us from the she-wolf and the wolf, and guard us from the thief,
> oh Night, and so be good for us to pass.
>---
> þ 9850.87 þ Fatal Database Error #10070: Sysop late for work
Jay Hostetter
Database Administrator
D. and E. Communications
Ephrata, Pa. U.S.A
jhostetter_at_dande.com
Received on Wed Oct 23 1996 - 00:00:00 CEST