Re: Fetch out of sequence in cursor

On Mon, 28 Aug 2006 22:05:08 GMT, "PAUL MADDSION" <60_pm_at_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