Mail Notification of Database Update

[punkdba]

All,

Through the magic of PHP, users are now able to submit ChangeRequests (oh, yeah -- THAT\'s exciting...not).  My HTML FORM is using a \'action=\"post\"\' to forward the HTML variables to a php_script which binds them to variables & inserts a record into an Oracle8.1.7 database.
 I\'d like to also receive an email notification each time this occurs.  Metalink has been less-than-useful, here.  I figure that I might use an Oracle-supplied package [called by a trigger on insert] (e.g., DBMS_PIPE).  Alternatively, perhaps there\'s a way to BOTH send the data to the php_script AND send (unix \"tee\") that data to a unix/perl/php script which sends an email... Yadda, yadda, yadda.  
 So, let me know your thoughts on this -- I\'m a wee bit overwhelmed by the task & could use some help.  There are usually many ways to do these things.  Of course, the easiest is just dandy with me -- I\'m EVER soooooo lazy!  I look forward to your comments/suggestions.

[ace21]

in the same script that inserts the data into the database have it send you a mail using the mail function builtin to php. You can read up on emailing in the php manual.

Ace21

[punkdba]

Thanks, Ace21 -- the simplest seems to be the best. Oracle's UTL_SMTP seems to be a nice -- perhaps better -- was to send the notification from a trigger/procedure. The only problem: its a #$@!* to properly configure the JSERVER/Java component to use this facility. Again, thanks for your help!

Todd
... lendin' validity to all that stuff they say about DBAs...