Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Trigger to send email message
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
>
>
Haven't done it yet, but the solution should be:
create a daemon program (c? pro-c?) that receives messages from your trigger by the dbms_pipe package. This program then handles the communication with the unix mail system. Received on Fri Jun 26 1998 - 07:25:25 CDT