title: odbcCommand with oracle procedure does not update records
body: <p>I am calling Oracle Stored Procedure in C# using odbc, i have written the following code</p>
  
  <pre><code>    OdbcCommand cmd = new OdbcCommand("{CALL sp_UpdateFileStatus(?)}", con);              
      cmd.CommandType = CommandType.StoredProcedure;
      cmd.Parameters.AddWithValue("@Param", OdbcType.Int).Value = 74;
      int rows = cmd.ExecuteNonQuery();
  </code></pre>
  
  <p>cmd.ExecuteNonQuery() always returns 1  it does not update the records in table, when i run procedure in Oracle SQL Developer it works perfectly. i don't understand what is wrong here.
  i have checked connection string it is perfect. Can any one help what can be wrong here?</p>