A technique in Oracle Database Development

This article also serves as a reference for using. NET Framework.

First, in JDBC:
Oracle JDBC does not support executing multiple statements at a time. One solution is as follows: String str = "BEGIN ";
Str + = "OPEN? For select * from emp ;";
Str + = "OPEN? For select * from emp ;";
Str + = "END ;";

CallableStatement cs = m_dbConn.prepareCall (str );
Cs. registerOutParameter (1, oracle. jdbc. OracleTypes. CURSOR );
Cs. registerOutParameter (2, oracle. jdbc. OracleTypes. CURSOR );
Cs.exe cute ();
// Get the rows from each resultset returned by the anonymous block
ResultSet resultSet = (ResultSet) cs. getObject (1 );
While (resultSet. next ())
{
System. out. println ("RS1:" + resultSet. getInt (1 ));
}
ResultSet = (ResultSet) cs. getObject (2 );
While (resultSet. next ())
{
System. out. println ("RS2:" + resultSet. getInt (1 ));
}

In. NET Framework, using OracleClient to execute multiple SQL statements also has the same problem.
This article introduces the following:
Http://www.cnblogs.com/attraction/archive/2004/06/05/13665.aspx