Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: help: How to send email in PL/SQL

Re: help: How to send email in PL/SQL

From: <NeedaHoliday>
Date: Wed, 11 Jul 2001 08:17:36 -0400
Message-ID: <umgoktsckoje4ihk5lf5ki834t0hts8m8m@4ax.com>

For what it's worth, we use the communication protocol DBMS_PIPE to send a message to the UNIX Listeners. We use Pro*C to capture the message and build a Kornshell script emailing us when an error occurs.

On Wed, 11 Jul 2001 11:51:14 GMT,
u518615722_at_spawnkill.ip-mobilphone.net wrote:

>One of our PL/SQL need to send email to us when finished. So far, we
>are using perl scripts to look through the output file, to search for
>"PL/SQL procedure successfully completed", is there any way we can send
>the email in the PL/SQL itself?
>
>Thanks
>
  Received on Wed Jul 11 2001 - 07:17:36 CDT

Original text of this message

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