OracleDependency does not fire an event

Question

I have an Oracle connection to an ORACLE 10.2 database and you want to listen to the changes in the table. The connection user has been granted the "CHANGE NOTIFICATION" privilege.

Listening is performed using the following method:

private OracleDependency SubscribeToTable(string tableName)
{
  string sql = "select * from " + tableName;
  var cmd = new OracleCommand(sql, this.connection) { AddRowid = true };
  var dep = new OracleDependency(cmd);
  cmd.Notification.IsNotifiedOnce = false;
  dep.OnChange += this.dep_OnChange;
  cmd.ExecuteNonQuery();
  return dep;
}

When I insert a row into the observed table and commit, the dep_OnChange event never fires. What am I doing wrong?

UPDATE:

, DBA Oracle ip-, (SELECT * FROM user_change_notification_regs). IP- VMWare, , . , .

Answer 1

?

Answer 2

oracletabledependency. Tabledependency.codeplex.com

.