Re: Trigger to send email message

Mark,
A simple approach might be to write a file with the TIO package and write a file to a directory. Write a simple shell script which runs every 5 minutes (cron) and checks the directory for files (emails). The shell script then sends

the files as emails.
This saves you writing a PRO*C program with alerts/pipes.

Just an idea
Raymond

Mark Greaves wrote:

> I need to write a trigger that will send out an email message with
> information about what changes were made to a table. The trigger logic is
> not a problem, but I don't know how to issue a "mail" command from within a
> trigger (PL/SQL). I am on a UNIX machine, so would be using the "mailx"
> utility. Does anyone have any suggestions for this?
>
> Thanks,
>
> Mark Greaves
Received on Tue Jun 30 1998 - 03:02:45 CDT