执行存储过程报错ora-12571 ora-02063 ora-06512,存储过程如下:
CREATE OR REPLACE PROCEDURE p_wxb_dj_fzchrdxx(v_sssq_q in date,
v_sssq_z in date)
is
li_max int;
li_row int;
begin
delete from TEMP_FZCHRDXX;
--commit;
/* insert into TEMP_FZCHRDXX
select T1.NSRSBH,
(select max(a.DJXH) from dw_nsr_zhxx a where a.nsrsbh = t1.nsrsbh) djxh,
T1.NSRMC,
T1.JYFW,
T1.SCJYDZ,
T1.FZR,
(select max(a.fddbrsfzjlx_dm)
from dw_nsr_zhxx a
where a.nsrsbh = t1.nsrsbh) frzjlx,
T1.FZRZJHM,
T1.RDYY,
T1.ZGSWJG,
T1.RDRQ,
seq_whsw.nextval,
sysdate,
'I'
FROM WHGS.GS_FZCDJXX T1;*/
insert into TEMP_FZCHRDXX
select b.NSRSBH,
a.djxh,
b.NSRMC,
b.JYFW,
b.SCJYDZ,
b.FDDBRXM,
b.FDDBRSFZJLX_DM,
b.FDDBRSFZJHM,
a.rdyy,
a.rdSWJG_dm,
a.RDRQ,
seq_whsw.nextval,
sysdate,
'I'
from hx_dj.DJ_FZCHRDXX@js.wuhan a, sjck_dw.dw_nsr_zhxx@js.wuhan b
where a.rdswjg_dm like '14201%'
and a.JCFZCHRQ is null
and a.djxh = b.djxh
and a.rdrq >= v_sssq_q
and a.rdrq <= v_sssq_z;
commit;
----导入网信办数据库
delete from FZCHRDXX@wxb.wuhan1
where rdrq >= v_sssq_q
and rdrq <= v_sssq_z;
commit;
select max(to_number(DATA_UP_UUID)) into li_max from TEMP_FZCHRDXX;
select min(to_number(DATA_UP_UUID)) - 1 into li_row from TEMP_FZCHRDXX;
while li_row < li_max loop
insert into FZCHRDXX@wxb.wuhan1
SELECT *
FROM TEMP_FZCHRDXX
where to_number(DATA_UP_UUID) > li_row
and to_number(DATA_UP_UUID) <= li_row + 1000;
COMMIT;
li_row := li_row + 1000;
end loop;
end p_wxb_dj_fzchrdxx;
墨值悬赏

评论
