62,614
社区成员
发帖
与我相关
我的任务
分享
//获得hibernate连接
Connection conn =session.connection();
String stringQueny = " {:varRef= call PKG_IMPORT_RCF.F_RCFDATA_PREPROCESS(:FLIGHTNO" +
", :CITYCODEORIGIN" +
", :AWBNO" +
", :MON" +
", :DD" +
", :SEQNO) } ";
CallableStatement cstmt = conn.prepareCall(stringQueny);
//注册返回参数
cstmt.registerOutParameter("varRef", oracle.jdbc.OracleTypes.VARCHAR);
//设置参数
cstmt.setString("FLIGHTNO", orgImportRcf.getFltId());
cstmt.setString("CITYCODEORIGIN", orgImportRcf.getCityCodeOrigin());
cstmt.setString("AWBNO", orgImportRcf.getAwbNo());
cstmt.setString("MON", orgImportRcf.getMonthScheduledArrival());
cstmt.setString("DD", orgImportRcf.getDayScheduledArrival());
cstmt.setString("SEQNO", Long.toString(orgImportRcf.getSequenceNo()));
cstmt.execute();
FUNCTION F_RCFDATA_PREPROCESS(FLIGHTNO NVARCHAR2,
CITYCODEORIGIN IN NVARCHAR2,
AWBNO NVARCHAR2,
MON NVARCHAR2,
DD NVARCHAR2,
SEQNO NVARCHAR2) return varchar2 is
varRef varchar2(1):='0';