Re: Can oracle notify an application

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: Thu, 22 Jan 2009 01:00:14 -0800 (PST)
Message-ID: <a96c3e81-9eca-4356-a7ac-f03b6558a95a_at_r34g2000vbp.googlegroups.com>

On Jan 22, 8:30 am, "ahanj..._at_gmail.com" <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?

Streams AQ provides asynchronous notifications, which can be received via JMS or OCI callback functions.
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14250/oci09adv.htm#sthref1553 details how async notifications are implemented with OCI.

Hth,

   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)    http://www.dynamicpsp.com Received on Thu Jan 22 2009 - 03:00:14 CST