How to use trigger to send mail via built-in AIX mailer?
From: Scot Balfour <scot.balfour_at_lmco.com>
Date: 1997/05/16
Message-ID: <337CBAC9.3F54_at_lmco.com>#1/1
Date: 1997/05/16
Message-ID: <337CBAC9.3F54_at_lmco.com>#1/1
Could someone please post or send me offline (scot.balfour_at_lmco.com) a PL/SQL fragment that creates a trigger that can:
- build a simple message body like: Order #5 was deleted by user: XYZ
- send this message with a subject to multiple users via AIX sendmail
For now, the fragment could just have hard-coded e-mail addressees; they could be read from a table down the road if the concept works.
Also, what code is added so the trigger can read/include a flat file from the operating system, in the note body, for example? Thanks.
-- Scot Balfour COTS Integration and SupportReceived on Fri May 16 1997 - 00:00:00 CEST