Re: NO_DATA_FOUND EXCEPTION
From: George Dau <gedau{mim/isamail}_at_qld.mim.com.au>
Date: 1995/04/23
Message-ID: <D7H1z6.Dvr_at_mim.com.au>#1/1
Date: 1995/04/23
Message-ID: <D7H1z6.Dvr_at_mim.com.au>#1/1
You need to use a procedure and an EXCEPTION clause. Good examples in
the PL/SQL maunal V 1.0 on pages 4-20 4-21 (and around there). The idea is
you have in your procedure:
BEGIN
SELECT ROWS FROM TABLES WHERE CONDIDTION = TRUE;
EXIT;
EXCEPTION
WHEN NO_DATA_FOUND THEN
EXIT;
END;
That does nothing in the case of NO_DATA_FOUND - you could raise some other
exception, print a message, set a flag, win lotto or whatever you want in the
EXCEPTION clause. ged.
Received on Sun Apr 23 1995 - 00:00:00 CEST