How to check date variable filled with null
Hello,
i do not understand why i cant check a variable of type date for null.
Tried "is null" and "nvl", both dont work.
Can someone explain why?
greets
create or replace function odbcread.dateadd_workdays (d in date, w in integer)return dateisdw date;begin select datum into dw from ( select datum, rownum wd from prod_erp_001.kalender where datum >= d and datum <= d + 14 and arbeitstag = 'J' order by datum ) where wd = w ; if dw is null then dw := d + w; end if; dw := nvl(dw, sysdate); return dw;end;/select odbcread.dateadd_workdays(sysdate, -8) from dual;
2