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

From: Alkos <azerty_at_nospam.org>
Date: Fri, 31 Oct 2003 15:10:00 +0100
Message-ID: <bntqfp$m862@news.rd.francetelecom.fr>

"Norman Dunbar" <Norman_at_RE-MO-VE.BountifulSolutions.co.uk> a écrit dans le message news:
pan.2003.10.31.13.51.35.711858_at_RE-MO-VE.BountifulSolutions.co.uk...
> 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.
>
>

Yes !
This is, of course, much clearer ;o) Received on Fri Oct 31 2003 - 08:10:00 CST