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