Package jp.co.kindlingsoft;
Import java.sql.CallableStatement;
Import java.sql.Connection;
Import Java.sql.DriverManager;
Import Java.sql.ResultSet;
Import java.sql.SQLException; public class TestDB {public static void main (string[] args) throws ClassNotFoundException, SQLException {String
Driver = "Oracle.jdbc.driver.OracleDriver";
String url = "Jdbc:oracle:thin: @localhost: 1521:kin";
String user = "KIN";
String password = "KIN";
Connection con = null;
CallableStatement stmt = null;
ResultSet rs = null;
Class.forName (driver);
con = drivermanager.getconnection (url, user, password);
stmt = Con.preparecall ("{Call Get_data (?,?)}");
Stmt.registeroutparameter (1, Oracle.jdbc.OracleTypes.CURSOR);
Stmt.registeroutparameter (2, Oracle.jdbc.OracleTypes.CURSOR);
Stmt.execute ();
rs = (ResultSet) stmt.getobject (1); while (Rs.next ()) {System.out.println (Rs.getobject (1));//Rs.getobject (column_name)} System.out.println ("******* *****************************************");
rs = (ResultSet) stmt.getobject (2);
while (Rs.next ()) {System.out.println (Rs.getobject (1));
}
}
}
CREATE OR REPLACE PROCEDURE get_data (
cur_out_1 out Sys_refcursor,
cur_out_2 out sys_refcursor) is
The BEGIN
OPEN cur_out_1 for
SELECT user_tab_cols. column_name from
user_tab_cols
WHERE table_name = ' TABLE1 ';
OPEN cur_out_2 for
SELECT user_tab_cols. column_name from
user_tab_cols
WHERE table_name = ' TABLE2 ';
End Get_data