title: oracle ExecuteNonQuery freezes on ASP.Net
body: <p>I am trying to run a non query using a Oracle connection in ASP C# with CLR 4.5. Here is my code:</p>
  
  <pre><code>    string connectionString = ConfigurationManager.ConnectionStrings["OracleConnectionString1"].ConnectionString;
      OracleConnection conn = new OracleConnection(connectionString);
      conn.Open();
      OracleCommand cmd = new OracleCommand();
      cmd.Connection = conn;
      cmd.CommandText = "update SALES_ADVENTUREWORKS2012.SALESORDERDETAIL set UNITPRICEDISCOUNT=0 where ROWGUID='4A399178-C0A0-447E-9973-6AB903B4AECD'";
      cmd.CommandType = CommandType.Text;
      cmd.CommandTimeout = QUERY_TIMEOUT;
      int row_affected = cmd.ExecuteNonQuery();
      HttpContext.Current.Response.Write("Rows affected:" + row_affected + "&lt;br/&gt;");
      conn.Close();
  </code></pre>
  
  <p>when I run the query in oracle development tool, it works fine.
  when I use the asp code above, it freezes when performing the query. It freezes forever even though I used a 5 second timeout.
  I've tried using the managed and unmanaged oracle libraries; both behave the same.
  Note that using the fill or scalar query work perfectly fine so there is nothing wrong with my connection string. Also the fact that oracle development can perform this update query proves that this is not a permission problem.</p>
  
  <p>Any ideas?</p>