SQL & PL/SQL

Hi,

Below is my code. Am trying to return a value without a out parameter in the procedure. Is out parameter is mandatory to return a value in a procedure. Please help.

CREATE OR REPLACE
PROCEDURE P123(
    PID NUMBER)
AS
  VCOUNT NUMBER;
BEGIN
  SELECT COUNT(*) INTO VCOUNT FROM EMP WHERE EMPNO=PID;
  IF (VCOUNT=1) THEN
    RETURN 1;
  ELSE
    RETURN 0;
  END IF;
END;

Thanks