Hi,
I am use Ref Cursors to read multiple data in batch query. Its work fine but problem is Command Time out not works in case of batch reading. Without Cursor, Command Time out works. My Sample Code is
// Oracle.ManagedDataAccess.Client
cmd = new OracleCommand(@"begin
open : 1 for select * from Table1;
open : 2 for select * from Table2;
end;", con);
cmd.Parameters.Add(new OracleParameter("1", OracleDbType.RefCursor, ParameterDirection.InputOutput));
cmd.Parameters.Add(new OracleParameter("2", OracleDbType.RefCursor, ParameterDirection.InputOutput));
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandTimeout = 5;
//var a = cmd.ExecuteNonQuery();
reader=cmd.ExecuteReader();
while (reader.Read())
{
Console.WriteLine(reader.GetInt32(0)); //Just example
}
reader.NextResult();
while (reader.Read())
{
Console.WriteLine(reader.GetInt32(0)); //Just example
}