title: Parameterized query in Oracle trouble
body: <p>I'm using <code>Oracle.DataAccess</code> rather than the obsolete <code>System.Data.OracleClient</code> and I seem to be having trouble passing multiple parameters to my update query</p>
  
  <p>This works</p>
  
  <pre><code>OracleCommand.CommandText = "UPDATE db SET column1 = :param1 WHERE column2 = 'Y'"
  OracleCommand.Parameters.Add(New OracleParameter("param1", "1234"))
  </code></pre>
  
  <p>But I want to be able to pass multiple parameters</p>
  
  <p>Here's my full code</p>
  
  <pre><code>    OracleConn.Open()
      OracleCommand = OracleConn.CreateCommand()
      OracleCommand.CommandText = "UPDATE db SET column1 = :param1 WHERE column2 = :param2"
      OracleCommand.CommandType = CommandType.Text
      OracleCommand.Parameters.Add(New OracleParameter("param1", "1234"))
      OracleCommand.Parameters.Add(New OracleParameter("param2", "Y"))
      OracleCommand.ExecuteNonQuery()
  </code></pre>
  
  <p>My <code>SELECT</code> query seems to work when passing multiple parameters but not the update one</p>