悬赏100哪位高手能帮小弟我检查这个存储过程的异常

悬赏100谁能帮我检查这个存储过程的错误
CREATE   OR   REPLACE   PROCEDURE   UpdateField
IS
    CURSOR   cur   IS   SELECT   b.graphid,   b.landusername   as   qlr1   FROM   czdj_zd   a,   tddj_zdbasicinfo   b   where   a.zdid   =   b.graphid;
BEGIN
  FOR   cur_result   in   cur   LOOP
          BEGIN
              update   czdj_zd   set   qlr   =   cur_result.qlr1   where   zdid   =   cur_result.graphid;
          END
  END   LOOP;
END   UpdateField;
在oracle创建提示编译语法错误   谁能帮我改一下。


------解决方案--------------------
CREATE OR REPLACE PROCEDURE UpdateField
IS
CURSOR cur IS SELECT b.graphid, b.landusername as qlr1 FROM czdj_zd a, tddj_zdbasicinfo b where a.zdid = b.graphid;
BEGIN
FOR cur_result in cur LOOP
BEGIN
update czdj_zd set qlr = cur_result.qlr1 where zdid = cur_result.graphid
END
END LOOP;
END UpdateField;

------解决方案--------------------

lz，
CathySun118(斯年)
让你把loop中的update语句最后去掉;分号