达梦8
–增量抽取双公示许可信息到pdgxk

BEGIN

INSERT INTO cert_id_temp select cert_id from pdgxk.permit_cert a,pdgxk.enty_info b
where a.data_source = 3
and a.enty_id = b.enty_id
and a.update_time > (select max(SJC) from pdgxk.permit_cert_shuanggongshi);
–查出删除数据信息
delete from PDGXK.permit_cert_shuanggongshi
where cert_id in
(
select * from cert_id_temp
);

--根据更新时间增量抽取数据
insert into PDGXK.permit_cert_shuanggongshi
select cert_id,cert_number,cert_name,'认可',a.business_scope,
enty_name,b.unisc_id,organ_code,b.reg_no,'','',a.fr_name,
cert_start_date,cert_end_date,'监督管理局','0','310115',a.update_time,a.remark,'1',a.data_source,'1',a.enty_id,''
from pdgxk.permit_cert a,pdgxk.enty_info b 
where a.data_source = '3' 
and a.enty_id = b.enty_id
and a.update_time > (select max(SJC) from pdgxk.permit_cert_shuanggongshi);

END;
这是我写的存储过程但是运行显示临时表没有怎么处理呢,临时表是cert_id_temp这个