Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: any way to limit the number of iterations of a loop?

Re: any way to limit the number of iterations of a loop?

From: <bonanos_at_yahoo.com>
Date: Thu, 25 Feb 1999 06:13:34 GMT
Message-ID: <7b2pm8$3kj$1@nnrp1.dejanews.com>

> I was just wondering if anyone knows of a parameter (or something similar) for
> 8.0.5 that allows you to set a maximum number of iterations on a loop,
> regardless of the logic in the loop.
>
> Basically, I have a developer that created a 5 line loop that had faulty
> logic (basically, while(true) loop;) and ran for about 6 hours before it
> could be shut down, sucking about 80% of the CPU in the process.

Put a counter in the loop. if counter = max then EXIT

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Feb 25 1999 - 00:13:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US