Re: How to send a mail in PL/SQL

Try using the DBMS_PIPE in PL/SQL talking to an 'infinitely' looping SQLPlus script that looks at the output from the pipe. Use 'spool file.txt' and something like 'host mail person_at_address < file.txt' command to compose and issue mail message .

Klaus Freisleben <klaus_Freisleben_at_compuserve.com> wrote in article <3384B452.78A5_at_compuserve.com>...
> Hi everybody!
>
> 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?
>
> Thanks in advance
>
> Klaus Freisleben
>
> |---------------------------------------------------------------|
> | Klaus Freisleben Vienna, Austria |
> | Email: Klaus_Freisleben_at_Compuserve.com |
> | or: FreislebenK_at_Wien.spardat.at |
> | Tel.: +43 664 241 78 63 |
> |---------------------------------------------------------------|
>
  Received on Sun May 25 1997 - 00:00:00 CDT