title: Oracledependency event is not firing
body: <p>I have some problems using OracleDependency.</p>
  
  <p>I've read docs on msdn and oracle and copy some code to try it.</p>
  
  <p>However this is not working, the event on_my_event doesn't fire when the insert is done.</p>
  
  <p>Does anyone know why ?</p>
  
  <p>My user has CHANGE NOTIFICATION rights on the database. Oracle Server is 11.2.0.3.0.</p>
  
  <p>Here is the code :</p>
  
  <pre><code>using System;
  using System.Collections.Generic;
  using System.ComponentModel;
  using System.Data;
  using System.Drawing;
  using System.Linq;
  using System.Text;
  using System.Windows.Forms;
  using Oracle.DataAccess.Client;
  
  namespace WindowsFormsApplication1
  {
  public partial class Form1 : Form
  {
      string connection_string = "Data Source=My_srv;User Id=My_usr;Password=My_pwd;";
      OracleConnection connection = null;
      OracleDependency dependency = null;
      OracleCommand my_select = null;
      OracleCommand my_insert = null;
  
      public Form1()
      {
          InitializeComponent();
      }
  
      private void TB_insert_event(object sender, EventArgs e)
      {
          if (TB_insert.Text == "Name of your insert")
              TB_insert.Clear();
      }
  
      private void insert(object sender, EventArgs e)
      {
          connection = new OracleConnection(connection_string);
          my_insert = connection.CreateCommand();
          my_insert.CommandText = "INSERT INTO USR_DEV_TRUNK.WPARAM (wpa_codeparam) VALUES ('" + TB_insert.Text + "')";
          connection.Open();
          my_insert.ExecuteNonQuery();
          connection.Close();
      }
  
      private void Set_dep(object sender, EventArgs e)
      {
          OracleDependency.Port = 3048;
          connection = new OracleConnection(connection_string);
          connection.Open();
          my_select = connection.CreateCommand();
          my_select.CommandText = "SELECT wpa_codeparam FROM USR_DEV_TRUNK.WPARAM";
          dependency = new OracleDependency();
          dependency.AddCommandDependency(my_select);
          my_select.Notification.IsNotifiedOnce = false;
          my_select.ExecuteNonQuery();
          dependency.OnChange += new OnChangeEventHandler(on_my_event);
          TB_dependency.Text = "The dependency is set, do your insert to see if it works";
          connection.Close();
      }
  
      public void on_my_event(object obj, OracleNotificationEventArgs arg)
      {
          TB_dependency.Text = "Yay ! It worked !";
      }
    }
  }
  </code></pre>
  
  <p>I have two buttons :</p>
  
  <p>One to set my dependency (function (on click) : Set_dep)</p>
  
  <p>One to do my insert (function (on click) : insert)</p>
  
  <p>And i have two textboxs :</p>
  
  <p>One to get my insert (name : TB_insert)</p>
  
  <p>One to show the dependency state (name : TB_dependency)</p>