create or replace procedure add_new_classes (v_new_class_no in pls_integer,v_c_id classes.course_id%type,v_period classes.period,v_f classes.frequency%type,v_i classes.instr_id%type)
as
i pls_integer;
BEGIN
for i in 1..v_new_class_no 
loop
insert into classes (class_id, start_date,course_id,period,frequency,instr_id)
values (class_id_sec_car.nextval,sysdate,v_c_id,v_period,v_f,v_i);

end loop;
exception
when others then dbms_output.put_line('o eroare');
END;
