orcale 存储过程问题!!急
Josir 2009-03-03 11:17:48 之前是SQL数据库中的存储过程脚本,现在把其移植到oracle数据库中,但是提示“该存储过程无效”,请各位帮忙看下谢谢了:
--导入工资数据的存储过程
create or replace procedure pr_importwatadata(@par_year char(4),@par_period char(2)) as
begin
delete from xh_watadata;
insert into xh_watadata
(
cyear,
cperiod,
pk_deptdoc,
deptcode,
deptname,
psnid,
psncode,
psnname,
f_16,
f_17,
f_21
)
select
a.cyear,
a.cperiod,
c.pk_deptdoc,
c.deptcode,
c.deptname,
a.psnid,
b.psncode,
b.psnname,
d.jobname , --职务系数,后改成岗位
a.f_59 , --系数
a.f_21 --日工资
from wa_data as a left join bd_psndoc as b on a.psnid = b.pk_psndoc left join bd_deptdoc as c on c.pk_deptdoc = b.pk_deptdoc left join om_job as d on a.pk_om_job=d.pk_om_job
where
a.cyear = @par_year and
a.cperiod = @par_period and
a.classid = (select pk_wa_class from wa_waclass where vwaclassname='工资') and
a.dr = 0 and
b.psnclscope = 0 and
b.dr=0
order by
c.deptcode,
b.psncode
end pr_importwatadata