Downloads Documentation Forums Articles Sample Code Getting Started Tutorials Blogs 
import java.sql.SQLException;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import oracle.jdbc.driver.OracleDriver;
import oracle.jdbc.driver.OracleConnection;


public class RefCursor {  
  public static ResultSet getEmployees() {
    try {

      // Register Oracle JDBC driver
      DriverManager.registerDriver(new OracleDriver());
             
      // Obtain default connection
      Connection conn = new OracleDriver().defaultConnection();
        
      // Create any subsequent statements as a REF CURSOR        
      ((OracleConnection)conn).setCreateStatementAsRefCursor(true);

      // Create the statement
      Statement stmt = conn.createStatement();

      // Query all columns from the EMP table
      ResultSet rset = stmt.executeQuery("select * from emp");

      // Return the ResultSet (as a REF CURSOR)
      return rset;
    } catch (SQLException se) {
      se.printStackTrace();
    } 
    return null;  
  }

  public static void getDepartments( ResultSet[] rout ) {
    try {

      // Register Oracle JDBC driver
      DriverManager.registerDriver(new OracleDriver());
        
      // Obtain the default connection
      Connection conn = new OracleDriver().defaultConnection();

      // Create any subsequent statements as a REF CURSOR
      ((OracleConnection)conn).setCreateStatementAsRefCursor(true);

      // Create the statement
      Statement stmt = conn.createStatement();

      // do a simple query
      ResultSet rset = stmt.executeQuery("select * from dept");


      // return the ResultSet (as a REF CURSOR)
      rout[0] = rset;
    } catch (SQLException se) {        
      se.printStackTrace();
    }
    return; 
  }
}
E-mail this page
Printer View Printer View