Hi All,

I got the following errror when calling a function a select.

ERROR at line 1:
ORA-00937: not a single-group group function
ORA-06512: at "PUSER.USERQTOTALNOOFUSRS", line 8
ORA-06512: at line 1


PROCEDURE USERQTOTALNOOFUSRS
(
RCT1 IN OUT GLOBALPKG.RCT1
)
AS
BEGIN

OPEN RCT1 FOR
SELECT
COUNT(TUSER.UNIQUEID) - 2 AS COUNTOFUNIQUEID,
USERQTOTALNOOFUSRS_Function0(TORGANIZATION.ORGUNIQUEID) AS CountOfDecomm
FROM TUSER,
TORGANIZATION
WHERE TUSER.ORGANIZATIONID = TORGANIZATION.ORGUNIQUEID
AND TORGANIZATION.ORGNAME = 'TENROX' ;
END;


FUNCTION USERQTOTALNOOFUSRS_Function0
(
TORGANIZATION_ORGUNIQUEID INTEGER
)
RETURN INTEGER
AS
AssignmentVariable INTEGER;

BEGIN
SELECT COUNT(TUSER.UNIQUEID) INTO AssignmentVariable
FROM TUSER,
TORGANIZATION
WHERE TUSER.ORGANIZATIONID = TORGANIZATION_ORGUNIQUEID
AND (TORGANIZATION.ORGNAME = 'TENROX')
AND (TUSER.USERACCESSSTATUS = 4);
EXCEPTION
WHEN NO_DATA_FOUND THEN
BEGIN
AssignmentVariable := 0;
RETURN AssignmentVariable;
END;

WHEN TOO_MANY_ROWS THEN
BEGIN
AssignmentVariable := 0;
RETURN AssignmentVariable;
END;
RETURN AssignmentVariable;
END;

What's wrong.

Thanks in advance