Re: Sending Email notification with PLSQL

There isn't any reason that I can think of not to do it this way. One easy way to accomplish it would be to use a bang (!) system call to invoke a program which will send you the message you need (if Unix, then sendmail would work).

Using this method is fast and easy; it gets the job done. A second method would be to use a table driven process which has an agent that will turn the insert event into a mail message. I have used this form to good advantage more than once and like the range of things that I can cause to happen based on various events.

William

replace the GeeTeeEee with gte when replying by mail.

In article <33cff4ed.80435470_at_news.bctel.net>, matts_at_xxxnifcosynergy.com says...
>
>I have been looking for a way to notify me via e-Mail when someone
>enters a special area of my site. Since the whole site is created
>with plsql I would rather stay with it, having the whole project in
>the same language seems like a good idea to me. But then again a few
>of my good ideas have been shot down in the past.
>
>take out the XXX from my email if you want to e-mail me (getting sick
>of the spammers)
Received on Sat Jul 19 1997 - 00:00:00 CDT