title: How to solve "Procedure or function has too many arguments specified" exception?
body: <p>I have several stored procedures for updating different tables. And when I execute them I get the exception as follows         </p>
  
  <blockquote>
    <p>Procedure or function  has too many arguments specified        </p>
  </blockquote>
  
  <p>I tried answers found on over the internet but couldn't fix it.<br>
  Here is my code for one stored procedure        </p>
  
  <pre class="lang-cs prettyprint-override"><code>cmd.CommandText = "update_HS_HR_EMP_BANK_AADM";
  cmd.Parameters.Add("@appNo", SqlDbType.VarChar).Value = appNo;
  cmd.Parameters.Add("@BRANCH_CODE", SqlDbType.VarChar).Value = branch;
  cmd.Parameters.Add("@ACCOUNTNO", SqlDbType.VarChar).Value = account;
  cmd.Parameters.Add("@ACCOUNT_TYPE", SqlDbType.VarChar).Value = type;
  cmd.ExecuteNonQuery();
  cmd.Parameters.Clear(); 
  </code></pre>
  
  <p>This is my stored procedure        </p>
  
  <pre class="lang-sql prettyprint-override"><code>    ALTER PROCEDURE [dbo].[update_HS_HR_EMP_BANK_AADM] 
          @appNo int,
          @BRANCH_CODE VARCHAR(10),
          @ACCOUNTNO VARCHAR(50),
          @ACCOUNT_TYPE VARCHAR(1)        
  
      AS
      BEGIN
  
          Update [HS_HR_EMP_BANK_AADM]
          SET
              [BBRANCH_CODE]=@BRANCH_CODE
              ,[EBANK_ACC_NO]=@ACCOUNTNO
              ,[EBANK_ACC_TYPE_FLG]=@ACCOUNT_TYPE
              ,[EBANK_ACTIVE_FLAG]=1
              ,[LAST_MODIFIED_DATE]=GETDATE()
          Where App_no=@appNo
      END
  </code></pre>