一个简单的存储过程,总是有个报错,愁的
create or replace procedure gsdz_922 as
begin
update gssjdzb set gsdrsjl=(select count(*) from gsgxgs.SHAR_ENTERPRISEBASEINFOCOLLECT where to_char(if_jlscsj,'yyyy/mm/dd')=to_char(sysdate-1,'yyyy/mm/dd')),gszsjl=(select count(*) from gsgxgs.SHAR_ENTERPRISEBASEINFOCOLLECT)
where sjbm='SHAR_ENTERPRISEBASEINFOCOLLECT'and to_char(tjrq,'yyyy/mm/dd')=to_char(sysdate-5,'yyyy/mm/dd');
commit;
end;
/