Re: NO_DATA_FOUND EXCEPTION

From: <mal830c_at_dukepower.com>
Date: 1995/05/09
Message-ID: <3ooe19$bd1_at_data.interserv.net>#1/1

> sanctus2_at_annex.com () writes:
>
> Jack Schwartz
> Systems Analyst
> Great Western Bank
>
>Jack, you need to just handle the exception inside the PL/SQL block. If you don't want to do anything when it returns 'no
data found' then in that exception handler do nothing but give it a place to go. If it is inside the PL/SQL block, it will continue inside the block after leaving the exception. EX.

	Begin
	PL/SQL......
	........
	Exception
	   when no_data_found then
	      do nothing  


>>>>	End;

It will continue on because the Exception is inside the block. Received on Tue May 09 1995 - 00:00:00 CEST