how can i execute oracle multiple query ? RSS

• • Reply
  

  junmoney83

  Member

  55 Points

  86 Posts

  how can i execute oracle multiple query ?

  Feb 06, 2013 01:12 PM|LINK

  Hi, i am using oracle database (10g)

  and i need to query multiple select and fill dataset.

  But if i insert ";" to end of query. 

  There is an error(ORA-00911)

  How can i exeucte multiple query?

• • Reply
  

  Lannie

  Contributor

  3724 Points

  726 Posts

  Re: how can i execute oracle multiple query ?

  Feb 07, 2013 12:13 AM|LINK

  Show us more detail about what you are trying to do.

  Maybe JOIN, and other set operations can merge your work into one query for the dataset fill

• • Reply
  

  kszymaniak

  Member

  205 Points

  112 Posts

  Re: how can i execute oracle multiple query ?

  Feb 08, 2013 07:23 AM|LINK

  For Oracle database and for select command you should use two commands

  string select1 = "select somecolumns from some table";
  OracleCommand cmd1 = new OracleCommand(select1, oracoeconn);
  OracleDataReader dr1 = cmd1.ExecuteReader();
  dr1.Read();
  
  string select2 = "select somecolumns from sometable";
  OracleCommand cmd2 = new OracleCommand(select2, oracoeconn);
  OracleDataReader dr2 = cmd2.ExecuteReader();
  dr2.Read();

  for insert or update data -  using oracle transaction

  • Marked as answer by Young Yang - MSFT on Feb 18, 2013 08:30 AM