Re: Newbie question on triggers

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 26 Sep 1998 18:46:03 GMT
Message-ID: <361d2c63.10792414@netnews.worldnet.att.net>

On Fri, 25 Sep 1998 06:45:05 +0100, "davout" <davout_at_dial.pipex.com> wrote:

>For instance, I have an Oracle table holding standing data that used by the
>other app. An Oracle process adds a new record to the table. I use a
>trigger to capture that event. What can I do with the trigger to notify the
>other app??

Read up on Oracle's "Advanced Queueing" features. They should help you do what you want. Alternatively, you could look at the DBMS_PIPE package. It might offer a simple solution.

regards,

Jonathan Received on Sat Sep 26 1998 - 13:46:03 CDT