Re: Using a trigger to send an e-mail

From: Piotr Kolodziej <pkol_at_otago.gda.pl>
Date: Thu, 3 Dec 1998 09:39:40 +0100
Message-ID: <745ivc$7jg$1@sunrise.pg.gda.pl>

David Mortenson wrote in message =
<3665d58a.159080587_at_news.grnvle1.sc.home.com>...
>
> This is probably a common question, but...
>
> I need to send an e-mail when a database trigger is fired. I am
>initially going to be using it on UNIX, but will be using an NT server
>later on...
>
> Any suggestions?

Generally, it is not a good idea to perform any sophisticated actions at the trigger level. Better pass a message for example via dbms_pipe to the other oracle session which listens and passes requests to the external program. On unix, the easiest way may be writting a daemon script which weaks up, executes a sql script which looks for requests at the Oracle database level (for example by reading a dbms pipe) and generates unix script calling mail program with proper messages. You may also write /Pro*/C program instead.

Regards,
Piotr Kolodziej
pkol_at_otago.gda.pl Received on Thu Dec 03 1998 - 02:39:40 CST