compilation error in plsql

Hi,

I'm a new learner of pl/sql programing & try to write a basic function; however, I can't figure out why my function is not compiling correctly. Could someone pls let me know if you see where is the problem? This is 10g & I'm writing it using iSQL*PLUS.

CREATE OR REPLACE FUNCTION check_sal (empno employees.employee_id %TYPE)
RETURN boolean IS

   dept_id employees.department_id%TYPE;    sal employees.salary%TYPE;
   avg_sal employees.salary%TYPE;

BEGIN
   SELECT salary, department_id, INTO sal, dept_id FROM employees WHERE employee_id = empno;

   SELECT AVG(salary) INTO avg_sal FROM employees WHERE department_id = dept_id;

   IF sal > avg_sal THEN

      RETURN TRUE;
   ELSE
      RETURN FALSE;
   END IF;
END;
/
show errors

Errors for FUNCTION CHECK_SAL:

LINE/COL 	ERROR
8/4 	PL/SQL: SQL Statement ignored
8/34 	PL/SQL: ORA-00936: missing expression

TIA,
-Chris Received on Mon Apr 07 2008 - 14:59:04 CDT