NO_DATA_FOUND EXCEPTION
From: <sanctus2_at_annex.com>
Date: 1995/04/22
Message-ID: <3nbutc$4sp_at_news.annex.com>#1/1
Date: 1995/04/22
Message-ID: <3nbutc$4sp_at_news.annex.com>#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.
I want to be able to retrieve no records WITHOUT erroring out my trigger.
I'd appreciate any help on this issue.
Thanx....
Jack Schwartz
Systems Analyst
Great Western Bank
Received on Sat Apr 22 1995 - 00:00:00 CEST