title: OracleCommand not ended properly
body: <p>I have a query that checks if the user exists in a database. When I check this query through <code>OracleCommand</code> it causes exception and says that the <code>command</code> is not ended properly.</p>
  
  <p>Here is the query:</p>
  
  <pre><code>select count(*) as user_exists
   from users
    where upper(u_name) = upper('name')
    and u_password = DB_PKG_ACCESS.f_encrypt('pass')
    and (expiration_date is null or (expiration_date is not null and trunc(expiration_date) &gt;= trunc(sysdate)));
  </code></pre>
  
  <p>And here is the <code>command</code>:</p>
  
  <pre><code>OracleCommand cmd = new OracleCommand("select count(*) as user_exists from users where upper(u_name) = upper('name')"
         +" and u_password = DB_PKG_ACCESS.f_encrypt('pass')"
         +" and(expiration_date is null or(expiration_date is not null and trunc(expiration_date) &gt;= trunc(sysdate)));", con);
  cmd.Parameters.Add(new OracleParameter("name", textBox1.Text));
  cmd.Parameters.Add(new OracleParameter("pass", textBox2.Text));
  </code></pre>
  
  <p>Where am I wrong?</p>