title: ODP.NET Query based notification in Oracle
body: <p>am trying to use the query based notifications, but it seems to switch over to the object based notification for some reason. My environment is Oracle 11.2 ( I believe you need 11.1 or above for query based to work) and I have a select statement which retrieves a column which is of type NUMBER. (Again here my understanding is that only varchar2 and number columns work). I seem to get every change notification on the table and not just my flltered dataset</p>
  
  <p>As an example I've created a sample table called test_db_notification with a single column of type NUMBER.</p>
  
  <p>Added two entries in there as follows:</p>
  
  <pre><code>SELECT rowid,column1 FROM test_db_notification;
  
  ROWID                 COLUMN1
  
  AAAERnAAKAAEurNAAI       54 
  AAAERnAAKAAEurPAAA       63 
  </code></pre>
  
  <p>Here's my code to register for notification:</p>
  
  <pre><code>OracleCommand _cmdObj = _connObj.CreateCommand();
  _cmdObj.CommandText = " SELECT column1 FROM test_db_notification where column1 = 63";
  _dep = new OracleDependency(_cmdObj);
  _dep.QueryBasedNotification = true; 
  _dep.OnChange += new OnChangeEventHandler(_dep_OnChange);
  _cmdObj.Notification.IsNotifiedOnce = false;
  _cmdObj.AddRowid = true;
  _cmdObj.ExecuteNonQuery();
  </code></pre>
  
  <p>When I register and change the value of column1 where the current value is 54, I get back a notification saying the ROWID for 54 has been updated.
  I was expecting not to receive any notifications since my original query looks only at <code>column1 = 63</code>. </p>
  
  <p>Am I missing something here?</p>
  
  <p>Thanks</p>