create or replace procedure create_assignment(p_new_description IN assessments.description%type)
as
begin
insert into assessments (assessment_id,description)
values (assessment_id_seq.nextval,p_new_description);
end;