Re: Trigger on shared tables

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Wed, 20 Aug 2003 22:31:13 GMT
Message-ID: <RES0b.102076$M5.86834@news02.roc.ny>

"Stefan Rupp" <st.rupp_at_t-online.de> wrote in message news:bi086g$kkb$01$1_at_news.t-online.com...
> Shalom!
>
> For a new project we need to interface with a third party product via
> shared Oracle tables. Whenever the other product writes a row into a
> table, our application has to read the table and process the new data.
>
> For this to work I thought about having an insert trigger on that table
> which informs our application about the new data to be read. What
> methods exist that I can use inside the trigger to trigger some action
> of our application? Is it possible to send a signal to our process?
> How do other interfaces work? I don't want to use active polling on the
> table.
>
> Regards,
> Stefan
>

What process are you talking about?. You need to be more elaborate to expect a meaningful reply.

Like the other poster replied, signals can be sent via dbms_alerts .. however, it might be overkill or unsuitable for what you plan to do.

.. and while you are at it .. its wise to post the oracle version/OS when asking questions.

Anurag Received on Wed Aug 20 2003 - 17:31:13 CDT