title: PL/SQL compilation error during update
body: <p>Query </p>
  
  <pre><code>DECLARE
    v_vendor_id NUMBER;
  BEGIN
    FOR vp_rec IN ( SELECT * FROM vpprocess )
      LOOP
        SELECT i.vendor_id INTO v_vendor_id FROM item i, lineitems l WHERE l.itemid = i.itemid AND l.id = vp_rec.lineitemid;
          EXCEPTION
              WHEN no_data_found THEN SELECT 0 INTO v_vendor_id FROM dual;
        UPDATE vpprocess SET vendorid = v_vendor_id WHERE vpprocessid = vp_rec.vpprocessid;
      END;
    END LOOP;
  END;
  </code></pre>
  
  <p>Error Message </p>
  
  <pre><code> Error starting at line 1 in command:
  DECLARE
    v_vendor_id NUMBER;
  BEGIN
    FOR vp_rec IN ( SELECT * FROM vpprocess )
      LOOP
        SELECT i.vendor_id INTO v_vendor_id FROM item i, lineitems l WHERE l.itemid = i.itemid AND l.id = vp_rec.lineitemid;
          EXCEPTION
              WHEN no_data_found THEN SELECT 0 INTO v_vendor_id FROM dual;
        UPDATE vpprocess SET vendorid = v_vendor_id WHERE vpprocessid = vp_rec.vpprocessid;
      END;
    END LOOP;
  END;
  Error report:
  ORA-06550: line 7, column 9:
  PLS-00103: Encountered the symbol "EXCEPTION" when expecting one of the following:
  
     begin case declare end exit for goto if loop mod null pragma
     raise return select update while with &lt;an identifier&gt;
     &lt;a double-quoted delimited-identifier&gt; &lt;a bind variable&gt; &lt;&lt;
     close current delete fetch lock insert open rollback
     savepoint set sql execute commit forall merge pipe
  ORA-06550: line 11, column 7:
  PLS-00103: Encountered the symbol "LOOP" when expecting one of the following:
  
     ;
  06550. 00000 -  "line %s, column %s:\n%s"
  *Cause:    Usually a PL/SQL compilation error.
  *Action:
  </code></pre>