title: DataTable Load method freezes or not by sql query (with same data)
body: <p>The code was working correctly about 1 hour ago (and still works correctly in test database).</p>
  
  <pre><code>public static int ExecuteNonQuery(String pCommand, CommandType pCommandType, ref OracleParameter[] pParameters)
  {
      int retVal = 0;
  
      using (OracleConnection connection = ConnectToDB())
      {
          using (OracleCommand command = connection.CreateCommand())
          {
              command.CommandType = pCommandType;
              command.CommandText = pCommand.ToString();
  
              if (pParameters != null)
              {
                  command.Parameters.AddRange(pParameters);
              }
  
              retVal = command.ExecuteNonQuery();
  
              DataTable dt = null;
  
              command.Parameters.Cast&lt;OracleParameter&gt;()
                  .Where(
                      p =&gt;
                          p.Value != DBNull.Value &amp;&amp; 
                          p.Direction == ParameterDirection.Output &amp;&amp;
                          p.OracleType == OracleType.Cursor)
                  .ToList()
                  .ForEach(p =&gt;
                  {
                      dt = new DataTable();
                      dt.Load((p.Value as OracleDataReader));
                      p.Value = dt;
                  });
          }
      }
  
      return retVal;
  }
  </code></pre>
  
  <p>but now it doesn't work correctly, at <strong>dt.Load</strong> line freezes. There is no known changes in query and in code. Same sql query, same source code but behaving is different.</p>
  
  <p>SQL query result contains 658 rows. We don't think that is about data count but tried increase data count from 1 step by step with <strong>ROWNUM &lt; X</strong> condition and it started working correctly. At the end <strong>ROWNUM &lt; 10000</strong> is a temporary solution for us but we still don't understand why it freezes at dt.Load line.</p>