RE: MAIL on insertion/updation of a record.

A few months ago I posted problems with using utl_smtp in a trigger. Trying to prevent the trigger from firing when the transaction is rolled back is a major hassle. Oracle doesn't know how to "roll back" the send mail command. The trigger would fire even when the insert/update was unsuccessful. What was surprising was that Oracle fired the "post" trigger when the triggering transaction failed. This was not an "autonomous transaction".

A few people scoffed at my claims, but, sure enough ,when they wrote their own they saw the same behavior.

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu
-----Original Message-----
Sent: Wednesday, October 03, 2001 3:10 AM To: Multiple recipients of list ORACLE-L

hi,
I have a requirement as per which i have to send a mail on insertion/updation of a record.
How this can be done using PL/SQL (i.e. triggers). Does mail server i.e. Lotus or Exchange server matters in this case.

regards
sunil s.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: SUNILSHIVAPPA
  INET: SUNILSHIVAPPA_at_infy.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: MacGregor, Ian A.
  INET: ian_at_SLAC.Stanford.EDU

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).