Re: 01555 and select statement

niy38_at_hotmail.com wrote:
> well, increment commit maybe not good, if I move commit outside loop,
> which has the consequence that I can not stop the script in the middle,
>
> even 99% of all record, otherwise all will rollback!

It appears then you are using cursor loops and this is something you should not be using in 9i.

Take a look at Array Processing in Morgan's Library at www.psoug.org. Array exception handling deals with this gracefully and far more efficiently then does the legacy coding you appear to be doing.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org