If I just run if and else by commenting out the middle condition, the code below works. But If I include the else if condition, it fails.
What am I doing wrong?
declare
P3_LOAN_PERIOD varchar2(11);
begin
if to_number(TO_CHAR(TO_DATE(:P3_PLP_LOAN_ENDS), 'MM')) = 12 and to_number(TO_CHAR(TO_DATE(:P3_PLP_LOAN_BEGINS), 'MM')) = 8
then P3_LOAN_PERIOD := 'FALL';
return P3_LOAN_PERIOD;
else if to_number(TO_CHAR(TO_DATE(:P3_PLP_LOAN_ENDS), 'MM')) = 5 and to_number(TO_CHAR(TO_DATE(:P3_PLP_LOAN_BEGINS), 'MM')) = 8
then P3_LOAN_PERIOD := 'FALL/SPRING';
return P3_LOAN_PERIOD;
else P3_LOAN_PERIOD := 'Other';
return P3_LOAN_PERIOD;
end if;
end;
thx for any tips!
Ceci