title: PL/SQL - Delete current record in FOR IN LOOP
body: <p>I am trying to figure out how to delete a record using the FOR .. IN .. LOOP</p>
  
  <pre><code>FOR REC IN (SELECT * FROM WORKLIST) LOOP
    GET_DATA(REC);
    --DELETE REC FROM WORKLIST
  END LOOP;
  </code></pre>
  
  <p>The GET_DATA procedure explodes every row to multiple ones so the current one becomes obsolete. I am trying to delete just the current record. Not sure if this is possible using the REC object in this case.</p>
  
  <p>Sadly, WORKLIST does not have any keys.</p>