17,377
社区成员
发帖
与我相关
我的任务
分享
Statement stmt = conn.createStatement();
stmt.execute("create or replace procedure proc_test999(pin number, pout out number) is " +
"begin " +
" pout := pin * pin; " +
"end;"); // 创建存储过程
stmt.close();
CallableStatement cstmt = conn.prepareCall("{call proc_test999(?,?)}"); // 调用存储过程
cstmt.setInt(1, 15);
cstmt.registerOutParameter(2, oracle.jdbc.OracleTypes.INTEGER);
cstmt.execute();
System.out.println(cstmt.getInt(2));
cstmt.close();