title: Why I'm getting the ORA-01003: no statement parsed error?
body: <p>Why am I getting this error and what does it mean by no statement parsed.</p>
  
  <pre><code> ORA-01003: no statement parsed 
  </code></pre>
  
  <p>Here is the code:</p>
  
  <pre><code>PROCEDURE ORIGINAL_TABLE.UPDATE_GROUPS   IS
  -- cursor loaded with the swam groups
  CURSOR cursor1 IS
      SELECT ID, NEW_DESCRIPTION
      FROM NEW_TABLE.NEW_GROUP_TABLE@DB_LINK.X;
  
  BEGIN
      FOR C1_REC IN cursor1 LOOP
          UPDATE
              ORIGINAL_TABLE."GROUPS"
          SET
              GROUP_ID = C1_REC.ID
          WHERE
              ORIGINAL_TABLE."GROUPS".DESCRIPTION = C1_REC.NEW_DESCRIPTION;
  
          IF (SQL%ROWCOUNT = 0) THEN
             INSERT INTO
                    ORIGINAL_TABLE.GROUPS("GROUP_ID", "DESCRIPTION")
             VALUES (C1_REC.ID, C1_REC.NEW_DESCRIPTION);
          END IF;
  
      END LOOP;
  
      EXCEPTION
      WHEN OTHERS THEN
           dbms_output.put_line(SQLERRM);
  END;
  </code></pre>
  
  <p>What I try to do with the code above is to update and old table with the values from a new table and in case that the new group doesn't exist insert it.</p>
  
  <p>Update: Changed %ROWCOUNT > 0 for %ROWCOUNT = 0</p>