Re: Trigger on shared tables

From: Stefan Rupp <st.rupp_at_t-online.de>
Date: Thu, 21 Aug 2003 17:32:11 +0200
Message-ID: <bi2olr$mhm$01$1@news.t-online.com>

Good afternoon,

Anurag Varma schrieb:
> 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.

You are right, I should have given more details, sorrz about that.

It's for Oracle 9i Rel. 2 on UNIX (both HPUX on IA64 and Linux x86).

The general idea is that the other side of the interface writes a record in a database table which should trigger our application (a C++ program) to read the record from the table for further processing. We are connecting to the database using an old version of the Rogue Wave DBTools library.

If I understood the hint of the other poster (thank you, Harald Maier) correctly, our C++ program needs to register a signal using a procedure from the dbms_alert package and then block in a call to dbms_alert.waitany to wait for the trigger on that table to throw that signal using the dbms_alert.signal procedure. Will that be quick enough?

Regards,
Stefan Received on Thu Aug 21 2003 - 10:32:11 CDT