Re: Can oracle notify an application
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 22 Jan 2009 14:37:07 +0000 (UTC)
Message-ID: <gla0aj$lub$4_at_solani.org>
On Thu, 22 Jan 2009 04:05:41 -0800, ahanjura_at_gmail.com wrote:
Date: Thu, 22 Jan 2009 14:37:07 +0000 (UTC)
Message-ID: <gla0aj$lub$4_at_solani.org>
On Thu, 22 Jan 2009 04:05:41 -0800, ahanjura_at_gmail.com wrote:
> Basically, I wanted an update to a oracle system table to callback my
> unix application (daemon) and refresh its internal data structures. All
> this should be done in near-real time (<few seconds)
Trigger should call DBMS_AQ and enqueue message. Your Unix application should connect to Oracle and see whether there are any messages.
-- Mladen Gogala http://mgogala.freehostia.comReceived on Thu Jan 22 2009 - 08:37:07 CST