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: Infinite loops possible in PL/SQL?

Re: Infinite loops possible in PL/SQL?

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: 2000/05/23
Message-ID: <392A8865.232F9CCC@edcmail.cr.usgs.gov>#1/1

Why not? Try:

DECLARE
  vNum NUMBER;
BEGIN
  vNum := 1;
  WHILE vNum > 0 LOOP

     vNum := 1;
  END LOOP;
END; HTH,
Brian

Shmooth wrote:
>
> I'm trying to produce an infinite loop using PL/SQL. Is this possible?
>
> I'm studying for my OCP exam and my book mentions how I should do
> different things to avoid these dastardly loops that can be cause when
> an exception handler throws another exception.
>
> Example that does *not* loop infinitely:
> -----------------------------------------------
> DECLARE
> status NUMERIC;
> num NUMERIC;
> BEGIN
> DBMS_OUTPUT.put_line('Beginning test...');
> num := 1/0; -- throw 1st exception
> DBMS_OUTPUT.put_line('Test successful...');
> EXCEPTION
> WHEN OTHERS THEN
> BEGIN
> status := SQLCODE;
> num := 2/0; -- throw nested exception
> END;
> END;
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================
Received on Tue May 23 2000 - 00:00:00 CDT

Original text of this message

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