Re: HELP: Commits Inside Cursor Loops

Mark Brayshaw wrote:
>
> I think a commit inside the cursor loop closes the cursor.
> If your doing a lot of updates you'll want to reduce the number of commits,
> while also
> ensuring that you don't have too many uncommitted updates to ensure you
> don't run
> out of rollback segments.
> Our practice was to build an outer control loop using a counter or a data
> condition from the table
> and moving the commit outside the cursor loop. That way you can tune the
> routine for optimum updates
> and minimum commits. It generally avoids the "Snapshot too old error' too.
>

That is incorrect. It does not close the cursor. Simple experiments would show that. Received on Wed Dec 08 1999 - 14:13:24 CET