Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Change Notification Clarification: OracleNotificationEventArgs Doesn't Include Delete When Updates o

4186764Feb 10 2020 — edited Feb 24 2020

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

This post has been answered by 4186764 on Feb 22 2020
Jump to Answer

Comments

Post Details

Added on Feb 10 2020
6 comments
263 views