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

Home -> Community -> Usenet -> c.d.o.tools -> infinite loop during exception handling?

infinite loop during exception handling?

From: Shmooth <shmooth_at_yahoo.com>
Date: 2000/05/09
Message-ID: <3918A28A.69E1B8D0@yahoo.com>#1/1

I'm studying for my OCP, first exam, and I'm trying to reproduce what my book says might be an infinite loop caused by one's exception handler throwing an uncaught exception of its own. I've done an example, but can't produce an infinite loop.

Am I doing something wrong?

Book I'm using is 'OCP Oracle DBA - Next Generation Training' by Willard Baird II, New Riders (c. 99; p. 108).

DECLARE
  status NUMERIC;
  num NUMERIC;
BEGIN
  DBMS_OUTPUT.put_line('Beginning test...');   num := 1/0;
  DBMS_OUTPUT.put_line('Test successful...'); EXCEPTION
WHEN OTHERS THEN
  BEGIN
    status := SQLCODE;
    num := 2/0;
  END;
END; Received on Tue May 09 2000 - 00:00:00 CDT

Original text of this message

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