create or replace procedure test_0 (fid in integer,reval out integer,reval1 out integer) as
begin
insert into test_1 values(fid);
commit;
reval := 10*fid;
reval1 := 20*fid;
end test_0;
public static void main(String[] args) throws Exception{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:BIDB","scott","tiger");
CallableStatement cs = con.prepareCall("{call test_0(?,?,?)}");
cs.setInt(1, 100);
cs.registerOutParameter(2, Types.INTEGER );
cs.registerOutParameter(3, Types.INTEGER);
cs.execute();
System.out.println(cs.getInt(2));
System.out.println(cs.getInt(3));
con.close();
}
