Write a 3GL program(I use 'C') that will communicate to Oracle via the
DBMS_PIPE routines.
If you are running V7.3 or later you can also use the UTL_FILE routines to
actually write your message into the file on the UNIX box. After writing
the file, use PIPEs to communicate with the 3GL program which then executes
the host command SENDMAIL. This can also be used to issue other host
commands as needed. Look in the Application Developer's Guide for examples
of using PIPEs in this manner.
--
Thomas W. Vanya
Oracle and OracleRdb Database Administrator
Eastman Chemical Company
-------------------------------------------------------------------------
(Due to proliferation of spammers, remove nospam from address.)
David A. Gershman <dgers_at_pizza> wrote in article
<632qe2$ceh_at_hacgate2.hac.com>...
> Is there a way for PL/SQL to 'send out' an email?
>
> i.e. in UNIX a text file created with headers can be sent on its way by
the command:
>
> % sendmail -t < mail_message.txt
>
> Is there PL/SQL way of doing the same?
>
> --
>
> "Artificial Intelligence: Making computers behave like they do in the
movies."
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~
> David A. Gershman : SSE Lab Administrator, MTS Comp Sci/Math
> HITS, Fullerton California - dgers_at_sed.hac.com
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~
>
Received on Tue Oct 28 1997 - 00:00:00 CST
