/**
* @author Hyacinthe MENIET
* Created on 17 janv. 2006
*/
package net.dotmyself.j2sql;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;

/**
* Displays data from Oracle.
*/
public class Ref2Java {

/**
* @param args
* @throws Exception 
*/
public static void main(String[] args) throws Exception {
  Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.8.1:1520:JBD","login","password");
  CallableStatement cstmt = conn.prepareCall("{call DEMO.get_contacts(?) }");
  cstmt.registerOutParameter(1,oracle.jdbc.driver.OracleTypes.CURSOR); // p_ref
  cstmt.executeQuery();
  ResultSet rs = (ResultSet) cstmt.getObject(1);
  while (rs.next()) {
    System.out.println(rs.getInt("C_ID")+". "+rs.getString("C_FIRSTNAME")+" "+rs.getString("C_NAME"));
  }
  rs.close();
  cstmt.close();
  conn.close();
}

}