Store Procedure Questions

From: Toh Hong Giep <thonggie_at_mercury.starnet.gov.sg>
Date: 1997/06/04
Message-ID: <5n34tf$ntl@io.starnet.gov.sg>#1/1

  I have a store procedure which made use of the 'SQL%FOUND' and 'SQL%NOTFOUND' attributes after a select statement.

  However this doesn't seemed to work as expected. When there is no data, the store procedure will terminate abnormally giving the error that no data is found!! I did not have an exception statement for the store procedure. My code goes something like this:

	SELECT .....
	If SQL%FOUND then
		.....
	End if;

	Doesn't this handle the "exception" when there's no data selected.  And 

if I were to include an exception statement at the bottom of the procedure, will the program continue to execute from the point where the exception happened, after the exception has been handled???

        Thanks for the invaluable help and advise. Regards to all Received on Wed Jun 04 1997 - 00:00:00 CDT