Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: NO_DATA_FOUND exception

Re: NO_DATA_FOUND exception

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Sun, 14 Sep 2003 12:02:20 +1000
Message-ID: <3f63ccd7$0$18592$afc38c87@news.optusnet.com.au>


"-={Giorgio}=-" <leva.md3496_at_mclink.it> wrote in message news:bjvm8m$14tp$1_at_newsreader2.mclink.it...
> >>BEGIN
> >
> > begin

> [...]

> > EXCEPTION
> >
> >> WHEN NO_DATA_FOUND THEN
> [...]

> > end;
> [...]

> >
> >>END;
> >>/
> >
> >
> > You're just not accepting exceptions in the right spot.
> >
>
> Exceptions should propagate to the caller until they find
> a handler... in this case having another block for the
> exception make the code a bit cleaner but it's not relevant
> for the exception itself.

But there is no way of knowing exactly where the exception started from, unless you add code. This blocking also makes it bullet proof against any change in behaviour or bugs. I like to start from "defensive" programming and progress to find the problem. It's a lot easier. ;)

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam
Received on Sat Sep 13 2003 - 21:02:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US