Re: sending e-mail from Oracle Forms application

-- 
There are two ways of sending an Email message from Oracled that I know
of.  The first is to purchase a product from Oracle called Alert.  This
will give you the ability to send Email.  If you dont want to use this
product,  there is a way of doing it with Pro*C (or any other
pre-compiler).  PL/SQL has a Package called DBMS_PIPE.  You can utilize
this package to send a request from PL/SQL to a pro*C program.  The C
program can then send the E-mail. The C program acts as a listener, and
can launch commands based on what requests it gets through the pipe. 
You can use this technique to launch any OS process, including Email. 
Oracle has a bulletin which explains how to do this(Prob ID#
1005666.6).  It is a little too long to include here,  but I would be
happy to forward it along.

--Dave


===============================================================

 Dave Bornstein                                               
 Motorola
ISG                                                                           
 Email:         davidb_at_dma.isg.mot.com                        


===============================================================