Re: How can I send a mail message from Oracle database to a mail system?

This is a form or Pro*C solution not a Database Trigger answer.

I do a HOST (mailx -s "subject text" email-addr < /dev/null") ;

Or you could write more information to a file and mail it.

 HOST (mailx -s "subject text" email-addr < a_file") ;

Mike Brady (mbrady2_at_ix.netcom.com) wrote:
: "Carlos Gomes de Oliveira" <Carlos_at_iis.com.br> wrote:
 

: > How can I send a mail message from Oracle database to a mail system?
: > Is there another solution besides oracle mail/office?
: >
: > TIA
: >
: > Carlos Gomes
: >
: I've implemented this once, but it was kinda ugly. It involves
: dbms_pipe and a Pro*C program.
 

: The trigger just puts the message into a DBMS_PIPE pipe, and there's a
: constantly looping Pro*C program reading the pipe and issuing system
: calls to send the mail.

--
This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.