RE: MAIL on insertion/updation of a record.

From: Nirmal Kumar Muthu Kumaran <NIRMALK_at_qtel.com.qa>
Date: Wed, 03 Oct 2001 04:17:26 -0700
Message-ID: <F001.003A0376.20011003042518@fatcity.com>

I'm redirecting you to
http://asktom.oracle.com/pls/ask/f?p=4950:8:162284::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:319216860351,%7Bsend%7D%20and%20%7Bmail%7D

This link explains how to send email through developer2000 forms. Hope that using utl_smtp package, you can send mails through pl/sql triggers.

Rgds,
Nirmal.

-----Original Message-----

From:   SUNILSHIVAPPA [SMTP:SUNILSHIVAPPA_at_infy.com]
Sent:   Wednesday, October 03, 2001 1:10 PM
To:     Multiple recipients of list ORACLE-L

Subject:        MAIL on insertion/updation of a record.

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). Received on Wed Oct 03 2001 - 06:17:26 CDT