Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> infinite loop during exception handling?
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