Re: Email from Oracle

From: Leslie Sandiland <lhen_at_chevron.com>
Date: 1997/05/08
Message-ID: <01bc5bbe$0b0ac3e0$8e391b92@lhen-laptop-1.sr.chevron.com>#1/1

Yes, you can use DBMS_PIPE to build the command you want executed (i.e. mail a message to a specific id, execute a unix shell script, etc) . This will be executed from the server that the database resides on. It involves a little bit of coding because you have to write a program which remains as a background process on the server which is constantly reading the pipe. Thanks!
Leslie

adam.lewandowski_at_ae.ge.com wrote in article <862946507.21385_at_dejanews.com>...
> Is it possible to send an email message from Oracle? For example, when a
> given row is updated, an email is sent to an address given in a column of
> that row? Could triggers be used to accomplish this?
> We're using Oracle 7.3
> Thanks,
Received on Thu May 08 1997 - 00:00:00 CDT