触发器问题

Question

CREATE OR REPLACE TRIGGER "FHWZ"."TRI_CJ" BEFORE
DELETE ON "PROJECT_CJ" FOR EACH ROW declarev_cj_pronum project_hz_info.pronum%type;
v_cj_dwname project_hz_info.dwname%type;
cursor cur_cj is(select t.pronum,t.dwname from project_hz_info t where t.pronum=:old.pronum and t.dwname=:old.dwname);
 
begin
     open cur_cj;
     loop 
        fetch cur_cj into v_cj_pronum,v_cj_dwname;
        delete from project_hz_info s where s.pronum=v_cj_pronum and s.dwnamew=v_cj_dwname;
     exit when cur_cj%NOTFOUND;
     close cur_cj;
end;行号=14 列号=4 错误文本=PLS-00103：出现符号“;”在需要下列之一时： loop请教高手指点

Answer 1

 close cur_cj;后面加end loop;