Multiple Query

Multiple Query

Hi

I have a following problem:
trying to utilize multiple query feature but getting error about incorrect sql syntax (ORA-00933). I want to pass few sql queries into one command, then execute reader, fetch data from first query, then call NextResult and so on. Here is equivalent code:

  1.  string query = @"
  2.         SELECT * FROM Customers;
  3.         SELECT * FROM Orders;
  4.         SELECT * FROM Products;
  5.     ";

  7.     var command = conn.CreateCommand(query);

  9.     using (var reader = command.ExecuteReader())
  10.     {
  11.         while (reader.Read())
  12.         {
  13.             // Process customer data
  14.         }

  16.         reader.NextResult();

  18.         while (reader.Read())
  19.         {
  20.             // Process order data
  21.         }

  23.         reader.NextResult();

  25.         while (reader.Read())
  26.         {
  27.             // Process product data         
  28.         }
  29.     }
The query statements ends with semicolon, tried to remove the last semicolon but with the same error. What is wrong with this code? Is this feature available in oracle?