create or replace procedure show_missing_grades (p_start_date IN date DEFAULT ADD_MONTHS(SYSDATE,-12),p_end_date IN date DEFAULT SYSDATE)
as
cursor missing_grades_cur
is
select class_id,stu_id,status
from enrollments
where enrollment_date between p_start_date and p_end_date and
final_numeric_grade is null and final_letter_grade is null
order by enrollment_date;
begin
for v_rec in missing_grades_cur
loop
dbms_output.put_line('class_id '||v_rec.class_id||' student_id '||v_rec.stu_id||' status '||v_rec.status);
end loop;
end;

