title: Why this select query to Oracle(View) doesn't work?
body: <p>First I tested simple cases:</p>
  
  <pre><code>cmd.Parameters.Add(new OracleParameter(":paramCode", OracleDbType.NVarchar2)).Value = userCode;
  cmd.CommandText = "SELECT * FROM VIEWUSERDATA WHERE  Codigo = :paramCode";
  cmd.CommandType = System.Data.CommandType.Text;
  OracleDataReader reader = cmd.ExecuteReader();
  while (reader.Read())
  {
      //Works, retrieve data
  }
  </code></pre>
  
  <p>Another:</p>
  
  <pre><code>cmd.Parameters.Add(new OracleParameter(":paramRole", OracleDbType.NVarchar2)).Value = userRole;
  cmd.CommandText = "SELECT * FROM VIEWUSERDATA WHERE  Role = :paramRole";
  ...
  while (reader.Read())
  {
      //Also works
  }
  </code></pre>
  
  <p>But when join, doesn't work.</p>
  
  <pre><code>cmd.Parameters.Add(new OracleParameter(":paramCode", OracleDbType.NVarchar2)).Value = userCode;
  cmd.Parameters.Add(new OracleParameter(":paramRole", OracleDbType.NVarchar2)).Value = userRole;
  cmd.CommandText = "SELECT * FROM VIEWUSERDATA WHERE Role = :paramRole AND Code = :paramCode";
  ...
  while (reader.Read())//don't retrieve anything
  {
  }
  </code></pre>
  
  <p>Data exists, If I do the query in an external query editor(window) works fine.</p>
  
  <p>Thanks.</p>