Re: NO_DATA_FOUND EXCEPTION

I believe the Application Programmer's guide describes a method by which you code nested Begin...End statements as below:

create or replace procedure foo
is
begin

	begin
		<sql statement that returns 0 rows>
	exception
		when NO_DATA_FOUND
		;
	end;


	<remainder of procedure


exception


	<exception handlers>

The exact syntax may be off, but I think you get the picture: Trap the exception and do nothing.

If there are further questions e-mail me at the CSC address and I'll send along actual code I'm using in a procedure now.

HTH Eric A. Stephens
Syracuse, NY
estephe1_at_csc.com
eastephe_at_mailbox.syr.edu <MIME enabled> http://web.syr.edu/~eastephe Received on Tue Apr 25 1995 - 00:00:00 CEST