Re: NO_DATA_FOUND exception

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Sun, 14 Sep 2003 00:41:36 +1000
Message-ID: <3f632c9e$0$13416$afc38c87@news.optusnet.com.au>

"David" <auto90059_at_hushmail.com> wrote in message news:3f6304eb$0$10355$afc38c87_at_news.optusnet.com.au...

Try this:

> BEGIN

begin
> SELECT People.Name, People.Address
> INTO v_author, v_address
> FROM People, Authors
> WHERE People.PersonID = Authors.AuthorID
> AND address = People.Address
> AND author = People.Name;

   EXCEPTION
> WHEN NO_DATA_FOUND THEN
> DBMS_OUTPUT.PUT_LINE ('EXCEPTION RAISED?');
> RETURN FALSE;

   end;
   RETURN (v_author = author AND v_address = address);
> END;
> /

You're just not accepting exceptions in the right spot.

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam

Received on Sat Sep 13 2003 - 09:41:36 CDT