On Mon, 28 Aug 2006 22:05:08 GMT, "PAUL MADDSION"
<60_pm@blueyonder.co.uk> wrote:

>Thanks for the advice.
>
>Yes, I was using a for update in my cursor. I wanted to mark the
>successfully processed records so that I could delete them all in one go at
>the end of the procedure. I suppose the way round this is to delete them as
>I go (once I know processing have been successful) and issue a commit every
>x number of records.
>
>Paul

I'm not sure why you don't want to commit once. If you commit every n
records, you break up a logical transaction into multi physical ones
*and* you increase the chance of the dratted ora-1555 error ('snapshot
too old')

--
Sybrand Bakker, Senior Oracle DBA