Re: How to trap the row count from a Commit ?

On Fri, 31 Oct 2003 05:19:52 -0800, Richard Elliott wrote:

> I know the data is there somewhere. I'm running an update loop (5k
> rows/commit) to avoid the rollback segment too small issue. It works
> fine, but I have to do a count of the remaining rows to see if I need
> to loop again. It would be much faster if I could just see if the
> previous commit did 5k rows or not. How do I trap the "# of rows
> affected" from the commit ?
>
> Thanks !

This might (!) help :

http://www.jlcomp.demon.co.uk/faq/rowcount.html

Cheers,
Norm.

-- 
Delete the obvious bit from my email address to reply by email.