Why does my database change notification using Oracle.DataAccess.Client.OracleDependency occasionall
Environment:
Windows XP - SP3
Oracle 10g - patched to 10.2.0.4.0
ODP.NET - patched to 10.2.0.4.0
Programming in C# for .NET Framework v2 with Visual Studio 2005
The scenario:
I have a C# program that subscribes for change events on table using Oracle.DataAccess.Client.OracleDependency
There is a thread that is responsible for handling the processing required following a notification event that is in a wait state using Monitor.Wait( syncObject );
The Event handler that is registered on the Oracle.DataAccess.Client.OracleDependency instance to respond to the notifications calls Monitor.PulseAll( syncObject ) to wake up the processing thread.
The problem:
Oracle 10g - patched to 10.2.0.4.0
ODP.NET - patched to 10.2.0.4.0
Programming in C# for .NET Framework v2 with Visual Studio 2005
The scenario:
I have a C# program that subscribes for change events on table using Oracle.DataAccess.Client.OracleDependency
There is a thread that is responsible for handling the processing required following a notification event that is in a wait state using Monitor.Wait( syncObject );
The Event handler that is registered on the Oracle.DataAccess.Client.OracleDependency instance to respond to the notifications calls Monitor.PulseAll( syncObject ) to wake up the processing thread.
The problem:
0