java 调用Oracle存储过程
存储过程函数
CREATE OR REPLACE FUNCTION AddNewStudent (
p_FirstName students.first_name%TYPE,
p_LastName students.last_name%TYPE,
p_Major students.major%TYPE) return number IS
在java中调用
sql = "?=call ADDNEWSTUDENT(?,?,?)";
java.sql.CallableStatement callStmt = conn.prepareCall(sql);
callStmt.registerOutParameter(1,java.sql.Types.INTEGER);
......