Java
jdbc로 procedure call sample
seongsland
2011. 8. 5. 02:24
Connection con ;
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:TEST","scott","tiger");
CallableStatement cs;
cs = con.prepareCall("{? = call find_pwd(?,?,?)}");
cs.registerOutParameter(1,Types.VARCHAR);
//cs.registerOutParameter(1,Types.INTEGER);
cs.setInt(2,s_no_p);
cs.setString(3,gruhigh);
cs.setString(4,fname);
cs.execute();
result = cs.getString(1);
cs.close();