Re: E-Mailing from Oracle / Solaris?

>I need to be able to set up a trigger or similar system whereby upon a
>certain event taking place, Oracle sends an E-Mail. I cannot use a
>Solaris cron job as the E-Mail needs to be sent upon a certain event
>rather than at a set interval.

Well, apart from Oracle Mail (of which I know nothing), or maybe Oracle Alert, you could use dbms_pipe and a Unix daemon to start any Unix command. On the other hand, it might be easier to set up a crontab job which scans a certain directory for new files, having length > 0. Put some intelligence in the crontab job to take the first line of the file as the address, the second as the subject and all the rest as the message body. In your trigger, simply use dbms_file to generate the file, and make sure you don't use dbms_file.flush, for otherwise your crontab job might start processing the file when you're not done writing to it yet.

In fact, I try something like it at the end of next week, so let me know if you're interested for the results.

Arjan.

e-mail: avbentem at dds.nl Received on Fri Jul 17 1998 - 11:51:40 CDT