我的SQL是:
create or replace procedure crpdta.GetTmpData
is
begin
delete from crpdta.f4105_t;
commit;
insert into crpdta.f4105_t
select coitm,colitm,colotg,coledg,councs/10000 as councs,cocsin,from_jde_date(coupmj) as coupmj,couser,copid,cojobn,cotday,coccfl from
proddta.f4105 where coledg='07';
commit;
end;但执行总报错:execute crpdta.GetTmpData;ORA-06550: 第 2 行, 第 14 列:
PLS-00905: 对象 CRPDTA.GETTMPDATA 无效
ORA-06550: 第 2 行, 第 7 列:
PL/SQL: Statement ignored请教各位大侠,我急的用.谢谢!
分不够再加.
create or replace procedure crpdta.GetTmpData
is
begin
delete from crpdta.f4105_t;
commit;
insert into crpdta.f4105_t
select coitm,colitm,colotg,coledg,councs/10000 as councs,cocsin,from_jde_date(coupmj) as coupmj,couser,copid,cojobn,cotday,coccfl from
proddta.f4105 where coledg='07';
commit;
end;但执行总报错:execute crpdta.GetTmpData;ORA-06550: 第 2 行, 第 14 列:
PLS-00905: 对象 CRPDTA.GETTMPDATA 无效
ORA-06550: 第 2 行, 第 7 列:
PL/SQL: Statement ignored请教各位大侠,我急的用.谢谢!
分不够再加.
begin
crpdta.GetTmpData;
end;或者 exec crpdta.GetTmpData;
--你运行这个看有问题没
insert into crpdta.f4105_t
select coitm,colitm,colotg,coledg,councs/10000 as councs,cocsin,
from_jde_date(coupmj) as coupmj,couser,copid,cojobn,cotday,coccfl from
proddta.f4105 where coledg='07';