Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Atomically moving rows from one table into another
> another way is to use FOR UPDATE in your cursor and DELETE WHERE CURRENT OF,
> but you cannot use commits in this scenario until the cursor is closed
Actually it's just fine that you cannot commit inside the loop using this technique, otherwise you risk end up half-done and with ORA-1555...
-- Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer.Received on Fri Oct 04 2002 - 12:27:34 CDT