Re: NO_DATA_FOUND EXCEPTION

From: Michael Nolan <nolan_at_helios.unl.edu>
Date: 1995/04/23
Message-ID: <3nck4t$3pq_at_crcnis3.unl.edu>#1/1

sanctus2_at_annex.com () writes:

>I want to be able to retrieve no records WITHOUT erroring out my trigger.

Stick this at the end of your trigger:

EXCEPTION WHEN NO_DATA_FOUND THEN NULL; In general it is good programming practice to put exception clauses in your PL/SQL scripts, even if only to ignore the error(s) like in this case. (There are times when NO_DATA_FOUND is a serious problem.)

---
Michael Nolan, Sysop for the DBMS RoundTable on GEnie
nolan_at_tssi.com, dbms_at_genie.com, nolan_at_inetnebr.com
(posted from nolan_at_helios.unl.edu)

Received on Sun Apr 23 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: ballpe_at_cnb07v.hhcs.gov.au: "Re: NO_DATA_FOUND EXCEPTION"
Previous message: Fredrik Nyman: "Re: If db_block_size default - using size 8192"
In reply to: sanctus2_at_annex.com: "NO_DATA_FOUND EXCEPTION"
In reply to sanctus2_at_annex.com: "NO_DATA_FOUND EXCEPTION"
Next in thread: ballpe_at_cnb07v.hhcs.gov.au: "Re: NO_DATA_FOUND EXCEPTION"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message