RE: MAIL on insertion/updation of a record.

From: Thomas, Kevin <Kevin.Thomas_at_calanais.com>
Date: Wed, 03 Oct 2001 05:27:39 -0700
Message-ID: <F001.003A0470.20011003054018@fatcity.com>

I've actually got a piece of code that will allow you to use the unix mail facility, I think it was Rachel that passed this on to me and I kindof tweaked it a bit. If you want me to post it I can do.

K.
"hit any user to continue"

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com <http://www.calanais.com/>

-----Original Message-----
Sent: 03 October 2001 13:25
To: Multiple recipients of list ORACLE-L

I'm redirecting you to
http://asktom.oracle.com/pls/ask/f?p=4950:8:162284::NO::F4950_P8_DISPLAYID,F 4950_P8_CRITERIA:319216860351,%7Bsend%7D%20and%20%7Bmail%7D <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-----
Sent: Wednesday, October 03, 2001 1:10 PM 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 <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: Thomas, Kevin
INET: Kevin.Thomas_at_calanais.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------