Xref: alice comp.databases.oracle.misc:17246
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!news-peer.gip.net!news.gsl.net!gip.net!portc01.blue.aol.com!audrey01.news.aol.com!not-for-mail
From: iancrozier@aol.com (Iancrozier)
Newsgroups: comp.databases.oracle.misc
Subject: PL/SQL cursor question
Lines: 10
Message-ID: <1998070722430600.SAA06361@ladder01.news.aol.com>
X-Admin: news@aol.com
Date: 7 Jul 1998 22:43:06 GMT
Organization: AOL http://www.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