Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 01555 and select statement
niy38_at_hotmail.com wrote:
> even I have ora-1555 error, I still can run couple of times to update
> all record if
> commit inside loop.
>
> but with commit outside loop, too risky! espically it takes more than
> 10 days
> to complete.
More evidence of not using bulk binding. Look up array processing. You should see performance improve dramatically.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Wed May 10 2006 - 18:15:15 CDT