为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:windows
【CPU】:
【问题描述】*:Oracle函数迁移dm一直报错
CREATE OR REPLACE
function "GETDEFERDATE"(startdate date,deferDay number)
return date
is
enddate date :=startdate+deferDay-1;
holiday_num number:=0;
weekend_num number:=0;
nonework_num number :=0;
begin
--weekend_num:=weekend_count(startdate,enddate);
select nvl(count(1),0) into holiday_num from holiday a where a.hl_date is not null and a.hl_date > startdate and a.hl_date <= enddate;
nonework_num:=weekend_num+holiday_num;
if nonework_num !=0 then
enddate :=getDeferDate(enddate,nonework_num+1);
end if;
return enddate;
end;
报错信息是什么