title: Oracle - select AND delete in a procedure
body: <p>I need to return a rowset from an Oracle procedure, and then delete them in that same procedure. Is there a neat way of doing this without temp tables? Something like an in-memory cursor maybe?</p>
  
  <p>Basically I'm popping the records off a queue, and I want to avoid two round trips because it's a very frequent process.</p>