title: Continue MERGE after EXCEPTION
body: <p>Is it possible to continue a <code>MERGE</code> after an <code>EXCEPTION</code> ?</p>
  
  <pre><code>MERGE INTO copy_emp c
       USING employees e
       ON (c.employee_id = e.employee_id)
     WHEN MATCHED THEN
       UPDATE SET
         c.first_name     = e.first_name,
         c.last_name      = e.last_name,
         c.email          = e.email,
         c.phone_number   = e.phone_number,
         c.hire_date      = e.hire_date,
         c.job_id         = e.job_id,
         c.salary         = e.salary,
         c.commission_pct = e.commission_pct,
         c.manager_id     = e.manager_id,
         c.department_id  = e.department_id
     WHEN NOT MATCHED THEN
       INSERT VALUES(e.employee_id, e.first_name, e.last_name,
            e.email, e.phone_number, e.hire_date, e.job_id,
            e.salary, e.commission_pct, e.manager_id,
            e.department_id);
  
  EXCEPTION
      WHEN OTHERS THEN
          -- ?????
  </code></pre>
  
  <p>Apart retrieve the ID of the row who threw the exception and restart the <code>MERGE</code> ignoring this ID I do not see how to do.</p>
  
  <p>I'm using Oracle Database 10.</p>