Function Error:PL/SQL: ORA-00922: missing or invalid option
659467Sep 12 2008 — edited Sep 12 2008Sorry, I was capturing information from a remote customer site and my connection went down...I will update this once I get back in (if).
As I am struggling with this, can anyone see what's wrong with this function that I am trying to convert from SQL?
FUNCTION IEXCGQAbandoned_QID (
v_BDateTime DATE
,v_EDateTime DATE
,v_QueueID INT)
RETURN int
v_retval INT;
BEGIN
SELECT COUNT(DISTINCT iid) INTO v_retval
from queueinteractionsview
where iendtime between v_BDateTime and v_EDateTime
and didispositionid in (3,5)
and queueid = v_QueueID;
RETURN v_retval;
END;