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

dwillmot <dwillmot_at_msa.com> wrote in message news:<3BB4CE31.80675C07_at_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 - 03:21:41 CEST