Re: how do i send e-mail from an SQL*Plus script or PL/SQL procedure?

From: Girish Mohata <gmohata_at_yahoo.com>
Date: 2 Oct 2001 01:31:09 -0700
Message-ID: <42a840c2.0110020031.2fc433ed_at_posting.google.com>


chandra_2000_us_at_yahoo.com (chan01) wrote in message news:<480cb9d4.0110011721.46066a00_at_posting.google.com>...
> dwillmot <dwillmot_at_msa.com> wrote in message news:<3BB4CE31.80675C07@msa.com>...
> > i'd like to have some SQL*Plus scripts
> >
> > e-mail success or failure at the end.
> >
> > i'd also like to do the same with PL/SQL routines.
> >
> > i'm running Oracle 8i under UNIX.
> >
> > existing routines have a UNIX shell script
> > that will perform this task.
> >
> > but we may be required to omit the shell scripts
> > and work only with SQL*Plus script and PL/SQL
> > stored procedures.
> >
> > again, i'd like to e-mail a success or failure message
> > from SQL*Plus or PL/SQL.
> >
> > thanks in advance.
>
> I got the script it will send the email with attachment.
> i tested it, it was working.
> it is java and pl/sql storedproc.
> i can send it to you if you want!!!!!!!!!!
> Good Luck

Please send me a copy of the Script to send an email with an Attachment. Would highly appreciate.

Regards,
Girish -- gmohata_at_yahoo.com Received on Tue Oct 02 2001 - 10:31:09 CEST

Original text of this message