Question

oracle function 返回值不显示

create or replace function WF_CalcIcon(
StartTime IN DATE,
CloseTime IN DATE,
Adder IN NUMBER,
State IN NUMBER,
Timer IN FLOAT,
Alert IN FLOAT)
return NUMBER
IS
dt float;
begin
IF State > 1 then dt := Adder ;
ELSE
SELECT ( CASE WHEN Wk_Start > StartTime AND Wk_Close > CloseTime THEN CAST( CloseTime - Wk_Start AS FLOAT )
WHEN Wk_Start > StartTime AND Wk_Close < CloseTime THEN CAST( Wk_Close - Wk_Start AS FLOAT )
WHEN Wk_Close < CloseTime THEN CAST( Wk_Close - StartTime AS FLOAT )
ELSE CAST( CloseTime - StartTime AS FLOAT ) END ) into dt
FROM Sys_WkTime WHERE Wk_Start < CloseTime AND Wk_Close > StartTime;
dt := dt * 24.0 + Adder;
END IF;

IF dt > Timer then RETURN 2;
ELSIF dt > Alert then RETURN 1;
ELSE RETURN 0;
END IF;

end WF_CalcIcon;
求高手

Answer 1

不明白你意思，我猜是你调用方法有问题了
用select WF_CalcIcon(参数1.。。。。。) from dual;

如果过程对，它就能显示了