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

chan,

yes, please post the PL/SQL stored procedure to this newsgroup.

i've been looking at the Oracle product file $ORACLE_HOME/rdbms/admin/utlsmtp.sql
under Oracle 8.1.7

but my first test was unsuccessful.
any information would be appreciated.

namaste.

• doug w.

  ---

chan01 wrote:

> 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
Received on Tue Oct 02 2001 - 14:55:22 CEST