java调用Oracle的存储过程或函数

一:无返回值的存储过程

存储过程为：
CREATE OR REPLACE PROCEDURE TESTA(PARA1 IN VARCHAR2,PARA2 IN VARCHAR2)  AS
BEGIN
   INSERT INTO HYQ.B_ID (I_ID,I_NAME) VALUES (PARA1, PARA2);
END TESTA;

调用方法为:
CallableStatement proc = null;
proc = conn.prepareCall("{ call HYQ.TESTA(?,?) }");
proc.setString(1, "100");
proc.setString(2, "TestOne");
proc.execute();

二：有返回值的存储过程（非列表）

存储过程为：

CREATE OR REPLACE PROCEDURE TESTB(PARA1 IN VARCHAR2,PARA2 OUT VARCHAR2)  AS
BEGIN
   SELECT INTO PARA2 FROM TESTTB WHERE I_ID= PARA1;
END TESTB;

调用方法为:
CallableStatement proc = null;
proc = conn.prepareCall("{ call HYQ.TESTB(?,?) }");
proc.setString(1, "100");
proc.registerOutParameter(2, java.sql.Types.VARCHAR);
proc.execute();
String testPrint = proc.getString(2);
System.out.println("=testPrint=is="+testPrint);

三：函数

函数形如:
create or replace function f_get_class(ar_date in date,ar_offset in number,runFac varchar2) return varchar2 is
......
return(lv_classid);
exception
  when others then
  return null;
end f_get_class;

调用方法为:
CallableStatement cstmt=conn.prepareCall("{?=call f_get_class(?,?,?)}");
cstmt.setString(2, null);
cstmt.setInt(3, 0);
cstmt.setString(4, "07")
cstmt.registerOutParameter(1,java.sql.Types.VARCHAR);
cstmt.executeUpdate();
newClassid = cstmt.getString(1);
out.println(newClassid);