CREATE OR REPLACE
PROCEDURE p_wtzz_gz_track_record (xh VARCHAR2, zt VARCHAR2, clsm VARCHAR2, clr_dm VARCHAR2)
AS
js number;
BEGIN
select count(*) into js from t_mis_zbyx_wtzz_gz where upxh=xh and to_char(clsj,'yyyy-MM-dd')=to_char(sysdate,'yyyy-MM-dd');
if(js=0) then
insert into t_mis_zbyx_wtzz_gz(xh,upxh,zt,clsm,clr_dm,clsj)
select seq_mis_routine.nextval,xh,zt,clsm,clr_dm,sysdate from dual ;
ELSE
update t_mis_zbyx_wtzz_gz set zt=zt,clsm=clsm,clsj=sysdate
where upxh=xh and to_char(clsj,'yyyy-MM-dd')=to_char(sysdate,'yyyy-MM-dd');
end if;
commit;
END p_wtzz_gz_track_record;
数据库有数据 但是怎么执行js都是0,后来百度,有可能是输入的参数跟本身表字段冲突 导致不识别。改成这样就好了
PROCEDURE p_wtzz_gz_track_record (v_xh VARCHAR2, v_zt VARCHAR2, v_clsm VARCHAR2, v_clr_dm VARCHAR2)