Thank you very much Kris.

But I got an other error message.

SQL> execute USERQTOTALNOOFUSRS(:c)

PL/SQL procedure successfully completed.

SQL> print c
ERROR:
ORA-06503: PL/SQL: Function returned without value
ORA-06512: at "PUSER.USERQTOTALNOOFUSRS_FUNCTION0", line 33
ORA-06512: at line 1



no rows selected

SQL>


Even I modified the function USERQTOTALNOOFUSRS_FUNCTION0 as below


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

BEGIN
AssignmentVariable := 0;
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
NULL;
RETURN AssignmentVariable;
END;
WHEN OTHERS THEN
BEGIN
AssignmentVariable := 0;
RETURN AssignmentVariable;
END;
RETURN AssignmentVariable;
END;