c# - OracleDependency not firing event -
I have an oracle connection for the Oracle 10.2 database and want to hear for a table change.
Private OracleDependency SubscribeToTable (string filename) {string sql = "+ Choose" to + + the table name; Var CMD = New Oracle Commands (SQL, this.connection) {AddRowid = true}; Var deputy = new oraclediamondency (CMD); Cmd.Notification.IsNotifiedOnce = false; Dep.OnChange + = this.dep_OnChange; Cmd.ExecuteNonQuery (); Return representative; }
When I enter a line in the celebrated table and commit, the event dep_OnChange is never removed. What am i doing
Update:
After checking the troubleshooting list and after everything was okay, I connected to Oracle as DBA and tested the IP ad, which is notified There must be a change (selector * to user_change_notification_regs). For some reason the IP address used to point to a VMware virtual network adapter, although the notification request was initiated from the physical machine and not the VM. After deactivating that virtual network adapter, it all works like this.
Have you started shooting in trouble?
Comments
Post a Comment