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();
}
}
}