Home > DeveloperSection > Forums > Invalid character for ; using reader.NextResult
jacob rasel
jacob rasel

Total Post:88

Points:616
Posted on    February-09-2014 11:26 PM

 C# C# 
Ratings:


 1 Reply(s)
 1280  View(s)
Rate this:

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?



Pravesh Singh

Total Post:411

Points:2881
Posted on    February-09-2014 11:49 PM

Hi Jacob,

Remove the : when adding parameters to the command.

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

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


Don't want to miss updates? Please click the below button!

Follow MindStick