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

From: Mike Brady <mbrady2_at_ix.netcom.com>
Date: 1997/04/17
Message-ID: <5j402u$sa4@sjx-ixn8.ix.netcom.com>#1/1

"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. Received on Thu Apr 17 1997 - 00:00:00 CDT

This message: [ Message body ]
Next message: John Strange: "Re: How can I send a mail message from Oracle database to a mail system?"
Previous message: Michael J. Pantaleano: "Re: How can I send a mail message from Oracle database to a mail system?"
In reply to: Carlos Gomes de Oliveira: "How can I send a mail message from Oracle database to a mail system?"
Next in thread: John Strange: "Re: How can I send a mail message from Oracle database to a mail system?"
Reply: John Strange: "Re: How can I send a mail message from Oracle database to a mail system?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US