FUNCTION studentauth(p_username IN VARCHAR2,p_password IN VARCHAR2) RETURN BOOLEAN
IS
    l_count INTEGER;
BEGIN
    SELECT COUNT(*)
    INTO   l_count
    FROM   G11_STUDENT
    WHERE UPPER(G11_STUDENT.STUDENT_EMAIL) = UPPER(p_username)
        AND UPPER(G11_STUDENT.STUDENT_PASSWORD) = UPPER(p_password);
        RETURN (l_count > 0);
END;