Re: PL/SQL cursor question

From: Tom Scott <spam>
Date: Wed, 8 Jul 1998 08:28:49 -0700
Message-ID: <6o02mm$smc@newshub.atmnet.net>

IF MyCursor%NOTFOUND THEN

• your code here END IF;

Iancrozier wrote in message
<1998070722430600.SAA06361_at_ladder01.news.aol.com>...
>While running a PL/SQL program which uses a cursor, the program bombs at a
>certain select statement with the following message:
>no rows selected.
>Well, this is true for some of the data. The question is :
>How can I stop the program from bombing just because no rows are selected
for
>this select statement.
>I would like to place a value in a variable when no rows are found, instead
>of having the program abort.
>
>TIA
Received on Wed Jul 08 1998 - 10:28:49 CDT