forum

Home / DeveloperSection / Forums / Invalid character for ; using reader.NextResult

Invalid character for ; using reader.NextResult

Anonymous User256009-Feb-2014

string sql = @"SELECT sum(subtotal) FROM table1 WHERE clientid=:v1;" +

"SELECT * FROM table2  WHERE clientid = :v2 "

cmd = DBConnection.GetCommand();

cmd.CommandText = sql;

cmd.Parameters.Clear();

cmd.Parameters.Add(":v1", "Name1");

cmd.Parameters.Add(":v2", "Name2");

OracleDataReader reader = cmd.ExecuteReader(); //Error: Invalid Character

while (reader.Read())

{

  ..results from first query

}

reader.NextResult();

while (reader.Read())

{

  ..results from second query

}

.NET is not allowing reader.NextResults using binding variables? Why i am getting Invalid Character?


Updated on 09-Feb-2014
I am a content writter !

Can you answer this question?


Answer

1 Answers

Liked By