Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!sjc70.webusenet.com!news.webusenet.com!cyclone.bc.net!newsfeed.stanford.edu!postnews1.google.com!not-for-mail From: vslabs@onwe.co.za (Billy Verreynne) Newsgroups: comp.databases.oracle.server Subject: Re: sending an email from a table trigger (before inserting row) Date: 6 Jul 2003 22:52:44 -0700 Organization: http://groups.google.com/ Lines: 21 Message-ID: <1a75df45.0307062152.145a6bbd@posting.google.com> References: <1a75df45.0307030425.febba27@posting.google.com> NNTP-Posting-Host: 198.54.206.91 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1057557164 10159 127.0.0.1 (7 Jul 2003 05:52:44 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 7 Jul 2003 05:52:44 GMT Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:237035 Jeremy wrote > I don't think Jon was necessarily saying that the trigger was going to > do validation per se - perhaps just that under certain data conditions, > he would like to be able to send an e-mail based on an update to a > table. If you read it that way, do you have the same opinion? Yes. Besides the basic concept of transaction processing, there is also such a thing as debugging. And debugging is not a black art that is so scary to get into, that one needs to stand in awe and fear and rather use a send mail from a trigger. Know what we are at the end of the day Jeremy? Problem solvers. From DBA's to developers. What determines the difference between good and bad problem solvers? How well and to what extent a problem is solved. You want to tell me that that a crude method like send mail in a trigger can truly solve the problem, never mind that it will be introducing a whole bunch of other problems? -- Billy