... (design issue) ... Re: How to send a mail in PL/SQL

From: Advanced Technology Resources -- John Saletta <jsaletta_at_advtechres.com>
Date: 1997/06/04
Message-ID: <5n2m89$bfu@nntp.interaccess.com>#1/1

Thanks for the tip. We have been experimenting with DBMS_PIPE from C++ talking to MAPI with some success.

However, I would appreciate some advice on how to design a mail system where the messages will not be lost (I believe that DBMS_PIPEs lose their data if the server goes down).

Thanks.

In article <5mmfkk$sj7$1_at_newsreader.jvnc.net>,

"James N. Bower" <jim_at_acssoft.com> wrote:
>This is a multi-part message in MIME format.
>
>
>You can search for "blat" and ignore German newspaper entries. Blat sends
mail via SMTP. It is a command-driven utility which sends mail contained in a file.
> Anders Houlberg-Nielsen wrote in article
<338D4FDB.8FEA20AF_at_inet.uni-c.dk>...
>Michael Bouda wrote:Klaus Freisleben wrote:
> >
> > I've the problem that I need to send a mail after a condition raises in
> > a PL/SQL Procedure.
> >
> > Has anybody an idea how to do this?
> >
> You can use DBMS_PIPE to invoke an external mail-program on the server.
> MBo Which mail program to use if you are on an NT-SERVER
>
>Anders Houlberg-Nielsen
>
>
><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML 3.2//EN">
><HTML>
><HEAD>
><META content=text/html;charset=iso-8859-1 http-equiv=Content-Type>
><META content='"Trident 4.71.0544.0"' name=GENERATOR>
>
></HEAD>
><BODY>
>You can search for "blat" and ignore German newspaper entries.
Blat
>sends mail via SMTP. It is a command-driven utility which sends mail
contained
>in a file.
> Anders Houlberg-Nielsen<AHN_at_INET.UNI-C.DK> wrote in article
><338D4FDB.8FEA20AF_at_inet.uni-c.dk>... 
><HTML><BODY>Michael Bouda wrote:
><BLOCKQUOTE TYPE = "CITE">Klaus Freisleben wrote: 
> > 
> > I've the problem that I need to send a mail after a condition
raises
> in 
> > a PL/SQL Procedure. 
> > 
> > Has anybody an idea how to do this? 
> > 
> You can use DBMS_PIPE to invoke an external mail-program on the
server. 
> MBo
></BLOCKQUOTE>  Which mail program to use if you are on an NT-SERVER 
> 
>Anders Houlberg-Nielsen
></BODY></HTML>
>
>

Advanced Technology Resources, Inc.
John Saletta
(847) 255-2500 FAX: (847) 255-0688
jsaletta_at_advtechres.com Received on Wed Jun 04 1997 - 00:00:00 CDT