Last post Feb 08, 2013 03:23 AM by kszymaniak
Feb 06, 2013 09:12 AM|junmoney83|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?
Feb 06, 2013 08:13 PM|Lannie|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
Feb 08, 2013 03:23 AM|kszymaniak|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();
string select2 = "select somecolumns from sometable";
OracleCommand cmd2 = new OracleCommand(select2, oracoeconn);
OracleDataReader dr2 = cmd2.ExecuteReader();
for insert or update data - using oracle transaction