Re: Notification of data changes

From: Mladen Gogala <mgogala_at_adelphia.net>
Date: Wed, 20 Mar 2002 03:06:03 -0500
Message-ID: <a79fp3$jpr0n$1@ID-82084.news.dfncis.de>

On Tue, 19 Mar 2002 21:18:56 -0500, Rondo wrote:

> 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

DBMS_ALERT and DBMS_PIPE come to mind. Another way is to write an external procedure which would manipulate semaphores. On unix, you can write a suid external procedure (using setuid(0)) to execute "/etc/init 6" command. Clients are bound to notice that.

-- 
Mladen Gogala

Received on Wed Mar 20 2002 - 02:06:03 CST