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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: MAIL on insertion/updation of a record.

RE: MAIL on insertion/updation of a record.

From: SUNILSHIVAPPA <SUNILSHIVAPPA_at_infy.com>
Date: Wed, 03 Oct 2001 22:21:19 -0700
Message-ID: <F001.003A16C8.20011003222517@fatcity.com>

hi kevin,

                Some doubts :
        your mail mentions three files :
        mailserver_startup.sh
        mailserver.csh and 
        mail_server.sql.

        What i see in mail is only two attachments.
        mailhost.csh ????
        mail_server.sql.

        mail_server.sql looks ok to me.
        but mailhost.csh contains the statement like  command :=
'sprintf(SCmdLine,'' -s%s -e%s -t%s'',sub,dst,msg)'; 
        This gives the statement like sprintf(SCmdLine,' -s%s -e%s
-t%s',sub,dst,msg) on command prompt to execute.
        Don't we use anything like sendmail.

        please clarify. How it works and where are mailserver.csh and
mailserver_startup.sh files.

regards
sunil s.                 

-----Original Message-----
Sent: Wednesday, October 03, 2001 9:15 PM To: Multiple recipients of list ORACLE-L

Here we go folks....this was originally sent to Christopher Spence...

Hi Chrisopher,

It's based around the fact that I don't have access to the UTL_SMTP package.
Some of our DBs are still 7.3.4.2.0 and I'm not sure if we have access to
this utility. I don't want to bother the DBAs with it..grin.

It's basically comprised of three elements. A pl/sql package called mail_server. A unix shell script called mailserver_startup.sh and a unix c
shell script called mailserver.csh. I've attached them for you.

Basically run the package into your database. Place the two shell scripts
into a directory and run the mailserver_startup.sh like so:

$ksh mailserver_startup.sh

If you then do a:

$ ps -ef | grep mailserver

You should find that the mailserver.csh process is sitting in the backgound
running away as normal.

To send mail from within pl/sql, issue the command:

SQL> exec v_mail_server.send_mail('kevin.thomas_at_calanais.com','Subject matter','Message');

And that is that..any probs give me a shout.

Kev.
"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

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

It will be great...

-----Original Message-----
Sent: Wednesday, October 03, 2001 7:10 PM To: Multiple recipients of list ORACLE-L

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_DISPLAY ID,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_DISPLA YID,
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 -------------------------------------------------------------------- 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: 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: 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 Thu Oct 04 2001 - 00:21:19 CDT

Original text of this message

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