title: ORA-01036: illegal variable name/number for a simple query
body: <p>I am facing this issue for this very simple query. I don't understand the reason behind it.</p>
  
  <pre><code>    string strCon=myConnectionString;
      string strSql=string.Format("select * from tblUser where UserName like '{0}%'",":Name");
      OracleConnection conn = new OracleConnection(strCon);
      OracleCommand command = null;
      command = new OracleCommand(strSql, conn);
      command.CommandType = CommandType.Text;
      //Getting this value from a function it is a string type variable
      val = val.Trim().ToUpper().Replace("'", "''");
      command.Parameters.Add("Name", OracleType.VarChar, 80).Value = val;
      DataSet dsEmail = new DataSet();
      OracleDataAdapter da = new OracleDataAdapter(command);
      da.Fill(dsEmail);
  </code></pre>