title: ORA-01036 error on update query using c#
body: <p>I am getting error when I update a number and try to get back that number. I have already googled for this error but all codes suggest the same solution I have but still I get this error.</p>
  
  <pre><code>Oracle.DataAccess.Client.OracleException ORA-01036: illegal variable
  name/number at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()
  </code></pre>
  
  <p>Here is my C# code:</p>
  
  <pre><code>//add one to sequence and update it
  query = "update unique_sequences " +
      "set last_sequence_number=last_sequence_number + 1 " + 
      "where unique_sequence_table_name='person' " +
      "returning last_sequence_number into :outnumber";
  command.CommandText = query;
  OracleParameter last_number = new OracleParameter("outnumber", OracleDbType.Varchar2, 13);
  last_number.Direction = ParameterDirection.Output;
  
  command.Parameters.Add(last_number);
  command.ExecuteNonQuery();
  </code></pre>
  
  <p>where last_sequence_number is VARCHAR2(13 BYTE).</p>
  
  <p>Thank you in advance.</p>