Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Feb 08, 2013 07:23 AM by kszymaniak
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?
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
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();
string select2 = "select somecolumns from sometable";
OracleCommand cmd2 = new OracleCommand(select2, oracoeconn);
OracleDataReader dr2 = cmd2.ExecuteReader();
for insert or update data - using oracle transaction