Re: NO_DATA_FOUND EXCEPTION
From: Ana Silva <ana_at_lamar.ColoState.EDU>
Date: 1995/05/04
Message-ID: <3ob7c9$2jjh_at_lamar.ColoState.EDU>#1/1
: >In PL/SQL, if I do a SELECT INTO or a FETCH that returns 0 records, the
: >NO_DATA_FOUND EXCEPTION is raised. That's all well and good but what do
: >I do with it? If I write code to only do something if I RETRIEVE
: >records, why can't I ignore the NO_DATA_FOUND? It ends up generating an
: >error in my trigger and rolls back my transaction.
: >
Date: 1995/05/04
Message-ID: <3ob7c9$2jjh_at_lamar.ColoState.EDU>#1/1
: In article <3nbutc$4sp_at_news.annex.com> sanctus2_at_annex.com () writes:
: >In PL/SQL, if I do a SELECT INTO or a FETCH that returns 0 records, the
: >NO_DATA_FOUND EXCEPTION is raised. That's all well and good but what do
: >I do with it? If I write code to only do something if I RETRIEVE
: >records, why can't I ignore the NO_DATA_FOUND? It ends up generating an
: >error in my trigger and rolls back my transaction.
: >
SELECT * FROM table_name;
EXCEPTION
WHEN NO_DATA_FOUND THEN NULL;
Ana
Received on Thu May 04 1995 - 00:00:00 CEST