Re: Mail from Oracle!!
Date: 7 May 1998 11:01:01 -0700
Message-ID: <6issst$sff_at_nntp02.primenet.com>
On Solaris you have quite a few options.
You can write shell scripts and call them from your procedures using HOST command.
The procedure we followed is:
Crontab starts the job and spools the output to a file.
The next shell scripts check the output file and knows if it needs to send
an email. Then it calls the email script otherwise just bypasses email
altogether.
If an email needs to be sent the third script runs a character mode report
of the data we want and sends the output of that report using sendmail.
It worked out very well. One of the project leads was a good AWK programmer.
HTH Prasad Chavali
Manolo's wrote in message <01bd7956$cfeff5c0$34e800c8_at_511_0324>...
>Hello!!
>
> I need to send an e-mail trough a store procedure or a job running on the
>Database.
>
> I have'nt Oracle Office and the platform is Solaris.
>
> I will apreciatte any idea..
>
> mjerez_at_hotmail.com
Received on Thu May 07 1998 - 20:01:01 CEST