Hi,
I've recently started testing the Change Notification functionality for an application that I am working on. I'm getting the notifications, but not in the manner I expected, however this may be normal behavior.
I've noticed that when I delete rows I get the notification. However If I insert or update and also delete, I do not get the delete notification.
If I insert and update in a single operation I get notifications of both. It seems that the DELETE notification is ignored if it is in combination with either of the other two. I was wondering if this is expected behavior or if I have missed something in my implementation.
Regards,
Oracle.ManagedDataAccess Version: 4.122.18.3
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
"CORE 11.2.0.2.0 Production"
TNS for 64-bit Windows: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production