From: "Paul Brewer" <paul@paul.brewers.org.uk>
Newsgroups: comp.databases.oracle.server
References: <b3hcvh$rrm$1@mws-stat-syd.cdn.telstra.com.au> <c2Y6a.13155$4O5.9549@fe10.atl2.webusenet.com>
Subject: Re: SQL Default Question (Resent)
Date: Mon, 3 Mar 2003 20:20:38 -0000
Lines: 11
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: ppp-2-106.lond-b-1.access.uk.tiscali.com
Message-ID: <3e63bc5e_3@mk-nntp-1.news.uk.worldonline.com>
X-Trace: 3 Mar 2003 20:34:38 GMT, ppp-2-106.lond-b-1.access.uk.tiscali.com
Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed-east.nntpserver.com!nntpserver.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!kibo.news.demon.net!demon!mk-nntp-1.news.uk.worldonline.com!ppp-2-106.lond-b-1.access.uk.tiscali.com
Xref: newsfeed1.easynews.com comp.databases.oracle.server:178301
X-Received-Date: Mon, 03 Mar 2003 13:34:34 MST (news.easynews.com)

"JustAnotherDBA" <jadba@bellsouth.net> wrote in message
news:c2Y6a.13155$4O5.9549@fe10.atl2.webusenet.com...
> I would declare the select cursor in the declare section (without the into
> parameter) and then you can have control by doing fetch into and then
> checking the cursor-name%notfound value and setting num2 accordingly.
>
Why the need to post the wrong answer four times?

Paul