title: ORA-06550 exception while calling oracle stored procedure from C#
body: <p>I'm trying to call an oracle stored procedure from my C# application and I get the following error:</p>
  
  <blockquote>
    <p>ORA-06550: line 1, column 7:<br>
    PLS-00306: wrong number or types of
    arguments in call to 'DELETE_SEARCH'<br>
    ORA-06550: line 1, column 7:<br>
    PL/SQL: Statement ignored</p>
  </blockquote>
  
  <p>The procedure declaration is:</p>
  
  <pre><code>PROCEDURE delete_search (user_ip IN VARCHAR2)
  </code></pre>
  
  <p>and th C# code that suppose to call it is:</p>
  
  <pre><code>OracleCommand cmd;
  OracleParameter param;
  for (int i = 0; i &lt; data.Tables[0].Rows.Count; i++)
  {
      if (decimal.Parse(data.Tables[0].Rows[i][1].ToString()) &lt; numericUpDown1.Value)
      {
          cmd = new OracleCommand("delete_search", Form1.conn());
          cmd.Parameters.Clear();
          cmd.CommandType = CommandType.StoredProcedure;
          param = new OracleParameter();
          param.ParameterName = "ip";
          param.Value = data.Tables[0].Rows[i][0].ToString();
          param.Direction = ParameterDirection.Input;
          param.OracleType = OracleType.VarChar;
          cmd.Parameters.Add(param);
          Form1.adapter().SelectCommand = cmd;
          Form1.adapter().SelectCommand.ExecuteNonQuery();
      }
  }    
  </code></pre>
  
  <p>and of course the exception is thrown in the line:    </p>
  
  <pre><code>Form1.adapter().SelectCommand.ExecuteNonQuery();
  </code></pre>
  
  <p>What can be the problem?</p>