A message from database to C# application

Hi,

I have a C# Windows application and Oracle 9i database.
Is there a way to send warning/notification to the application from the database via open connection? Let's say, there is a table that has just been updated by another process (user) and a warning has to be sent to the application.
Thanks a lot in advance.

Vlad Turovets

I know is sql server 2000 there are notification services to allow this communication, but not sure about oracle. One solution would be to write to a file when an update occurs in the db, and use the filesystemwatcher in your application to prob the directory for changes.