Re: Using a trigger to send an e-mail

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Fri, 4 Dec 1998 18:42:37 +0100
Message-ID: <74970l$qnd$1@pascal.a2000.nl>

David Mortenson wrote
>Other than responsiveness (immidate action
>rather than polling), can you think of other reasons to consider
>DBMS_PIPE?
When you enter data into a table, you should also issue a commit to enable the polling process to see that data. You can not issue a commit in a trigger, and possibly do not even want that anyway. Using dbms_pipe, the message will always be processed by the listening process. That is: if there is a listening process...

Another option would be using dbms_alert. However, if an allert message is still awaiting processing, then new alerts will be ignored. So, whether to use dbms_pipe or dbms_alert is really a matter of functional design.

Arjan. Received on Fri Dec 04 1998 - 11:42:37 CST