Is there any event driven technique in oracle to u

Question

Is there any event driven technique in oracle to use with asp.net which should be capable of showing data in real time?

My requirement is simple but may be tricky..

I have an Oracle database containing weather data of different places which are changing time to time. I need to develop a web application to view those data from oracle in real time, that means as soon as a record is updated in database, the new value should be visible on the web page immediately.

For this, the select statement should be executed when a record is updated.

Any Idea?

Answer 1

No, the only way is to poll database at certain interval.

Answer 2

Yes using oracle database change notification feature. You have to use ODP.Net for this. Read the documentation on how to use this. This will allow a noiificationm from Oracle to your ASP.Net application.
An example is also proved here.

The other part is to have a push notification setup between the browser and server. This is possible using web sockets if you can use ASP.Net 4.5. However only IE 10 will support web sockets but firefox and chrome already does. There are alternate implementations as well such as superwebsockets. I haven't used this but SignalR library is worth checking out.