create or replace procedure MYPROCEDURE(workyear In varchar2,cdate in date) As
v_nid varchar2(100);
v_time date;
Begin
v_nid :=workyear;
v_time:=cdate;
update s_work_year set workyear=v_nid,cdate=v_time;
update t_gys_sequence set year = workyear;
update t_cl_sequence set year = workyear;
update t_hq_sequence set year = workyear;
update t_gys_empty_number set year = workyear;
update t_cl_empty_number set year = workyear;
update t_hq_empty_number set year = workyear;
end MYPROCEDURE;引用:
CallableStatement proc = null;
proc = conn.prepareCall("{CALL MYPROCEDURE(?,?)}");
proc.setString(1,year);
proc.setDate(2, new java.sql.Date(new java.util.Date().getTime()));
int flag = proc.executeUpdate();
System.out.println(flag);
return flag; 执行后数据已经更新,但是flag为什么总为0呢?
v_nid varchar2(100);
v_time date;
Begin
v_nid :=workyear;
v_time:=cdate;
update s_work_year set workyear=v_nid,cdate=v_time;
update t_gys_sequence set year = workyear;
update t_cl_sequence set year = workyear;
update t_hq_sequence set year = workyear;
update t_gys_empty_number set year = workyear;
update t_cl_empty_number set year = workyear;
update t_hq_empty_number set year = workyear;
end MYPROCEDURE;引用:
CallableStatement proc = null;
proc = conn.prepareCall("{CALL MYPROCEDURE(?,?)}");
proc.setString(1,year);
proc.setDate(2, new java.sql.Date(new java.util.Date().getTime()));
int flag = proc.executeUpdate();
System.out.println(flag);
return flag; 执行后数据已经更新,但是flag为什么总为0呢?
v_nid varchar2(100);
v_time date;
Begin
updateflg :=1;
v_nid :=workyear;
v_time:=cdate;
update s_work_year set workyear=v_nid,cdate=v_time;
update t_gys_sequence set year = workyear;
update t_cl_sequence set year = workyear;
update t_hq_sequence set year = workyear;
update t_gys_empty_number set year = workyear;
update t_cl_empty_number set year = workyear;
update t_hq_empty_number set year = workyear;
Exception When others then
updateflg :=0; end MYPROCEDURE;