import java.sql.*;
import oracle.sql.*;

public class oracle
{
 public static void main(String args[])
 {
  try
  {
   DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
      Connection con=DriverManager.getConnection("jdbc:oracle:oci8:@xukai","scott","tiger");
   
   
   
   CallableStatement ctst=con.prepareCall("begin  ?:=xukaipackage.xukaifun1(?); end;");
   ctst.registerOutParameter(1,oracle.jdbc.OracleTypes.CURSOR);
   ctst.setInt(2,20);
   ctst.execute();
   ResultSet rcc=(ResultSet)ctst.getObject(1);
   while(rcc.next())
   {
    System.out.println(rcc.getString(1)+","+rcc.getString(2)+","+rcc.getString(3)+","+rcc.getString(4)+","+rcc.getString(5)+","+rcc.getString(6)+","+rcc.getString(7)+","+rcc.getString(8));
      }
   
  }
  catch(Exception e)
  {
   e.printStackTrace();
  }
 }
}