RE: MAIL on insertion/updation of a record.

2001-10-03 Thread SUNILSHIVAPPA
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

RE: MAIL on insertion/updation of a record.

2001-10-03 Thread MacGregor, Ian A.
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 unsucce

RE: MAIL on insertion/updation of a record.

2001-10-03 Thread Thomas, Kevin
If we're talking about the NON-utl_smtp code, it works fine for me now. The only problem I had was making sure my unix mail server could connect with the outside world. We were on a development server that didn't have external mail facilities. ;o) K. -Original Message- Sent: 03 October

RE: MAIL on insertion/updation of a record.

2001-10-03 Thread Thomas, Kevin
Here we go folksthis 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.

RE: MAIL on insertion/updation of a record.

2001-10-03 Thread Rachel Carmichael
yes, but it doesn't use utl_smtp to generate the mail. I do know a couple of people on the list have used it, I'll let them talk about the trials and tribulations of setting that up Rachel --- "Thomas, Kevin" <[EMAIL PROTECTED]> wrote: > I've actually got a piece of code that will allow you to u

RE: MAIL on insertion/updation of a record.

2001-10-03 Thread SUNILSHIVAPPA
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. I

RE: MAIL on insertion/updation of a record.

2001-10-03 Thread Thomas, Kevin
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 Deregulatio

RE: MAIL on insertion/updation of a record.

2001-10-03 Thread Nirmal Kumar Muthu Kumaran
Title: RE: MAIL on insertion/updation of a record. 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