Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to trap the row count from a Commit ?
What about using a implicit cursor within a PL/SQL proc ?
Cursors have a fancy property called %ROWCOUNT
On the other hand, what about enlarging your RBS (if you can) ?
"Richard Elliott" <richard.a.elliott_at_williams.com> a écrit dans le message
news: 8c132b3c.0310310519.2963db99_at_posting.google.com...
> 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 !
Received on Fri Oct 31 2003 - 07:35:28 CST