Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to use trigger to send mail via built-in AIX mailer?

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@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:

  1. build a simple message body like: Order #5 was deleted by user: XYZ
  2. 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 Support
Received on Fri May 16 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US