Hi.
I am using Apex 4.2.1 on Oracle 11gR4 and mod_plsql.
I have a "central" web application (not necessarily Apex) that will make changes to my Oracle database.
I have several Apex apps that are "clients" to this central web app. I need to somehow signal these Apex client apps that the central app has made changes to the database. These client apps would then display these changes in various reports and forms.
I realize that I can have the client apps "poll" the database every n-secs/mins/whatever to check for changes. But this means making many network trips to/from the database. This can be done either using triggers or a background process. There's even an Apex dynamic action plugin that will let me do this polling.
But is there a more elegant (less network expensive) way to signal these client Apex apps of database changes?
Thank you.
Elie