Reply-To: "Michael O'Neill" From: "Michael O'Neill" Newsgroups: comp.databases.oracle References: <3a355fdd.22149078@news.pacbell.net> Subject: Re: Catching NoDataFoundException... Lines: 44 Organization: Bottom Line Party X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Message-ID: Date: Tue, 12 Dec 2000 02:49:20 GMT NNTP-Posting-Host: 24.11.25.230 X-Complaints-To: abuse@home.net X-Trace: news2.rdc2.tx.home.com 976589360 24.11.25.230 (Mon, 11 Dec 2000 18:49:20 PST) NNTP-Posting-Date: Mon, 11 Dec 2000 18:49:20 PST Try, select max(NVL(iteration_number), 0)) from iteration where release_name = blah "alan" wrote in message news:3a355fdd.22149078@news.pacbell.net... > I have a table that has a primary key consisting of 2 columns. One is > a release name. The other is a number which refers to an iteration > within that release. > > Such as > > current 1 > current 2 > soon 1 > > the release name refers to a release table which contains nothing but > the name. A release does not have to have spawned any iterations at > any given point in time. > > My problem is that I need to find out the next iteration number for a > given release when creating a new iteration. In the above example the > number for current should be 3 and the number for 'soon' would be 2. > > No problem so far. Within my Stored Procedure to add iterations I > simply look up the max iterationNumber. The problem arises if a > release does not yet have any iterations. Performing the search > > select max(iteration_number) from iteration where release_name = blah > > suddenly throws a NoDataFoundException. All I want it to do is return > 1, so I can create an iteration row. Is there any way I can establish > a default result that will return if no date is found? > > I would like to avoid using sequencies for each release because the > sequencies would be very brief and they seem complicated to set up at > run time. > > I'm sure this problem is surmountable, I'm just not sure where to look > for the answer... > > alan