DBMS_ALERT and DBMS_PIPE are ok as suggested, but I would also recommend
looking at AQ (Advanced Queuing) - this way you can set up a thread in your
client application that will be queue subscriber and trigger will be queue publisher.
Trigger will publish once, and all active subscribed clients will receive the message
and act accordingly. There's a number of available programmatic interfaces for AQ,
including OO4O, OCI, Java and PL/SQL (DBMS_AQ). OCI & OO4O clients can even
receive asynchronous notifications on new messages in queue, so you might not
even need to run a separate polling thread if you use OCI or OO4O.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Rondo" <ron_at_iesys.com.au> wrote in message news:miSl8.23$Ks6.3333_at_nsw.nnrp.telstra.net...
>
> I have a situation where one or more Win32 client applications are viewing
> database data live. Is there some way we can get the Oracle server to notify
> the clients that an insert record has happened on specific tables. I guess
> its a trigger
> but I don't know of a mechanism for communicating that back to the clients
> without
> polling.
>
> Ron
>
>
Received on Wed Mar 20 2002 - 07:26:47 CST
