Re: Can oracle notify an application
Date: Thu, 22 Jan 2009 14:19:44 GMT
Message-ID: <4g%dl.1437$aI1.447_at_nwrddc01.gnilink.net>
<ahanjura_at_gmail.com> wrote in message
news:cfc913c5-a9f9-4226-91d8-d83f730f2464_at_17g2000vbf.googlegroups.com...
On Jan 22, 2:44 pm, Frank van Bortel <frank.van.bor..._at_gmail.com>
wrote:
> ahanj..._at_gmail.com 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,
-Anubhav
Also you can use dbms_alert .
Jim
Received on Thu Jan 22 2009 - 08:19:44 CST