注册

Oracle函数迁移dm一直报错

ing 2024/02/22 426 2

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【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;

回答 0
暂无回答
扫一扫
联系客服