title: In .NET, How to execute this Oracle PL/SQL Procedure?
body: <p>My procedure is declare here :</p>
  
  <pre><code>create or replace
  PACKAGE MYPKG
  IS
  PROCEDURE MYPROCEDURE(
          sNom            IN VARCHAR2,
          sValeur         OUT VARCHAR2,
          sCommentaire    OUT VARCHAR2,
          sRetour         OUT VARCHAR2,
          sMsgRetour      OUT VARCHAR2);
  END;
  </code></pre>
  
  <p>The execution is Ok with SQL Developer.</p>
  
  <p>I try to execute this procedure in C# :</p>
  
  <pre><code>OracleCommand cmd = new OracleCommand("MYPKG.MYPROCEDURE", OraCon);
  cmd.CommandType = CommandType.StoredProcedure;
  OracleParameter name = new OracleParameter("sNom", OracleType.VarChar);
  name.Value = "CG";
  cmd.Parameters.Add(name);
  OracleParameter valeur = new OracleParameter("sValeur", OracleType.VarChar);
  cmd.Parameters.Add(valeur);
  OracleParameter commentaire = new OracleParameter("sCommentaire", OracleType.VarChar);
  cmd.Parameters.Add(commentaire);
  OracleParameter retour = new OracleParameter("sRetour", OracleType.VarChar);
  cmd.Parameters.Add(retour);
  OracleParameter msgRetour = new OracleParameter("sMsgRetour", OracleType.VarChar);
  cmd.Parameters.Add(msgRetour);
  
  using (OracleDataReader row = cmd.ExecuteReader())
  {
      while (row.Read())
      {
          Console.WriteLine(row.GetValue(0));
      }
  }
  </code></pre>
  
  <p>I have the error "Wrong Parameter".
  How execute the PL/SQL procedure ?</p>