一个关于触发器的问题，请大神们一定看看，在线等，急！

Question

不知道new的地方怎么错了

 create or replace trigger biufer_C_CL_TIMEEX
after insert
on C_CL_TIMEEX
for each row
declare
 i number;
 k number;
 j number;
begin
for i in 1..:NEW.count_week loop
    for k in 1..7 loop
        for j in 1..13 loop
            insert into C_CL_TIME(curr_time,
      start_year,
      stop_year,
      start_mon,
      stop_mon,
      count_week,
      week_num,
      week,
      lesson,
      timeex_id) values(
      :NEW.curr_time+createdby1.nextval,
      :NEW.start_year,
      :NEW.stop_year,
      :NEW.start_mon,
      :NEW.stop_mon,
      :NEW.count_week,
      i,
      k,
      j,
      :NEW.timeex_id);
        end loop;
    end loop;
end loop;
end;

Answer 1

提示报什么错，不建议嵌套太多的循环