Oracle PUSH to Desktop App
I have an app which needs to report to users certain database criteria in real time.
So it sits there and constantly polls the database whenever a timer event fires (usually every minute).
Very wasteful of CPU cycles and network traffic.
So, instead, is it possible for the Oracle (or SQL Server) database to send a message to my desktop app whenever certain triggered updates occur?
Ideally, the database should trigger a user event in my app.
Is it possible to "register" an app with Oracle to make this work?
All other ideas are welcome. (someone suggested NET SEND).