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


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

Original text of this message