CREATE OR REPLACE
FUNCTION GETDOTIME_FUN (IDS NUMBER, FLAGS NUMBER)
RETURN NUMBER
AS
V_SUM NUMBER;
BEGIN
if IDS is null then
V_SUM:=0;
ELSE IF FLAGS=2 THEN
select DoTime2 INTO V_SUM from MX_ServiceQuestion WHERE id=IDS;
ELSE
select DoTime INTO V_SUM from MX_ServiceQuestion WHERE id=IDS;
END IF;
END IF;
RETURN V_SUM;
END GETDOTIME_FUN;