title: Oracle Invalid number error from C#
body: <p>I run the below code in my C# .Net application, but I keep getting error <strong>ORA-01722: invalid number</strong>. When running the same SQL directly in PL/SQL Developer it does exactly what I ask it to without complaining.</p>
  
  <p>What could be causing this?</p>
  
  <pre><code>OracleCommand command = connection.CreateCommand();
  command.CommandType = CommandType.Text;
  command.CommandText = "insert into my_table ( select i.*, null from my_view i where i.usr_id is not null )";
  command.ExecuteNonQuery();
  </code></pre>
  
  <p>Note: I am using Oracle.DataAccess.Client</p>