Re: Can oracle notify an application

From: gym dot scuba dot kennedy at gmail <>
Date: Thu, 22 Jan 2009 14:19:44 GMT
Message-ID: <4g%dl.1437$>

<> wrote in message On Jan 22, 2:44 pm, Frank van Bortel <> wrote:
> wrote:
> > Can Oracle notify a running application (Unix) about a change in some
> > table data? something that the application can trap and take an action
> > on?
> Apart from the valuable comments, DBMS_PIPE may be a solution when all
> components are oracle.
> --
> Regards,
> Frank van Bortel

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)

Thanks for your comments,

Also you can use dbms_alert .
Jim Received on Thu Jan 22 2009 - 08:19:44 CST

Original text of this message