这样写合呼语法吗?
create or replace function f_stat
(
date_startime in date,
in_item in int)
RETURN float IS
return_value float;
declare
in_callnum int;
in_StatusA int;
BEGIN
case in_item
when 1 then return_value := 3
when 2 then return_value := 8
else return_value := 0
end;
end;
------解决方案--------------------不符合
可以用 if ... then .. end if;
------解决方案--------------------create or replace function f_stat
(
date_startime in date,
in_item in int)
RETURN float IS
return_value float;
in_callnum int;
in_StatusA int;
BEGIN
case in_item
when 1 then return_value := 3;
when 2 then return_value := 8;
else return_value := 0;
end case;
return return_value;
end;
------解决方案--------------------楼上说的有道理