title: No data when running SELECT from C# OracleDB
body: <p>I have a C# application that reads from a Oracle DB, but gets no data in my application. If I am running the same SELECT statement directly from the management tool, it returns the data fine.</p>
  
  <pre><code>static void Selectexample()
      {
         string connStr = @"Data Source=localhost;user id=system;password=123456";
  
  
         DbProviderFactory dbFactory= DbProviderFactories.GetFactory("System.Data.OracleClient"); 
  
          DbConnection con = dbFactory.CreateConnection();
          con.ConnectionString = connStr;
  
          string sql;
          sql = "SELECT * FROM person";
  
          DbCommand cmd = dbFactory.CreateCommand();
          cmd.Connection = con;
          cmd.CommandText = sql;
  
  
          try
          {   
              con.Open();
  
  
              DbDataReader reader = cmd.ExecuteReader();
  
  
              string headline = "";
              for (int i = 0; i &lt; reader.FieldCount; i++)
              {
                  string s = reader.GetName(i);
                  headline += s.PadLeft(20) + " | ";
              }
  
              Console.WriteLine(headline);
  
  
              while (reader.Read())
              {
  
                  string line = "";
                  string s1 = (string)reader[0];
                  string s2 = (string)reader[1];
  
                  line += ("");
                  line += s1.PadLeft(20) + " | ";
                  line += s2.PadLeft(20) + " | ";
  
                  Console.WriteLine(line);
  
              }
          }
          catch (DbException ex)
          {
              Console.WriteLine("fejl: " + ex.Message);
          }
          finally
          {   
              con.Close();
          }
  
          Console.WriteLine();
          Console.WriteLine("---");
      }
  </code></pre>
  
  <p>Table definition for Person:</p>
  
  <pre><code>create table person
  (
  cpr char(10) primary key,
  name varchar(25),
  job varchar(25),
  salary int,
  zip char(4),
  foreign key (zip) references zipcode(zip)
  );
  </code></pre>
  
  <p>I am running .Net 3.0 with x86 Oracle driver on x64 Windows</p>