create or replace procedure enter_student_grade (p_numeric_grade IN number, p_class_a_id IN number, p_class_id IN number, p_s_id IN number,p_a_id IN number)
as
begin
insert into class_assessments (class_assessment_id,date_turned_in,numeric_grade,class_id,stu_id,assessment_id)
values (p_class_a_id,sysdate,p_numeric_grade,p_class_id,p_s_id,p_a_id);
end;