Re: How do I get table updates from Oracle?

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Fri, 25 Oct 2002 02:58:34 GMT
Message-ID: <ur2u9.89428$zE6.309791_at_rwcrnsc51.ops.asp.att.net>


One method is to have a trigger that used dbms_alert.

1. Have a named alert for each type of table or query.
2. Have a trigger on each table update an alert.(raise)
3. Have the application register interest in the particular alert.
4. It will get notified when the alert fires.
Unlike dbms_pipe (which is a method also) dbms_alert wil notify any number of "clients" or interested parties.

You can have a thread that waits on the alert and calls the main program when a table needs to be updated.
Jim
"Tony Hoyt" <gmtonyhoyt_at_yahoo.com> wrote in message news:407a64e1.0210240525.749282a0_at_posting.google.com...
> The topic doesn't do justice for my request. So allow me a moment to
> try and explain what it is I need.
>
> I have a bunch of tables in an oracle database, at some point, they
> I'm going to have this database become part of a Master Site array in
> a replication setup. Now each of the master sites has it's own copy
> of our server software, which is an OCI application. Now in ram, some
> of those applications have copies of the tables, or a subset of the
> tables. Each time those tables are updated, so must the ram version
> must be too. What I need is someway for the OCI application to
> register with the database, some kind of trigger that activates a
> callback function to alert my system when a change has been made. The
> server application itself could make the change, or one of the other
> servers in the Master Site could have made the change. It doesn't
> matter, the thing is, whenever a change is made anywhere, to any
> table, an updated message needs to be made to the OCI application so
> that it updates it's Memory tables.
>
> Is this possable thru normal Oracle functionality or am I going to
> have to work out some hack?
>
> Tony
Received on Fri Oct 25 2002 - 04:58:34 CEST

Original text of this message