oracle上创建了这样一个存储过程
CREATE PROCEDURE T_LBSELE1
(OUT_NUM OUT varchar2)
AS
BEGIN
  SELECT FILE_TYPE_NO into OUT_NUM FROM T_LB WHERE FILE_TYPE_NO='06';
END T_LBSELE1;
用JDBC 如何取得OUT_NUM

解决方案 »

  1.   

    CallableStatement callstmt = null;
                callstmt = conn.prepareCall("{call T_LBSELE1(?)}");
                callstmt.registerOutParameter(1, Types.VARCHAR);
                String OUT_NUM = callstmt.getString(1);
      

  2.   

    CallableStatement callstmt = null;
                callstmt = conn.prepareCall("{call T_LBSELE1(?)}");
                callstmt.registerOutParameter(1, Types.VARCHAR);
                callstmt.executeQuery(); //提交一下得到
                String OUT_NUM = callstmt.getString(1);