Re: help!!!

Suggest you check for the NO_DATA_FOUND exception as below:

Chen Li wrote:

> Hi, All:
>
> I am writing a before insert trigger. I want to make a comparison
> between the new record and
> others which are already in the database. For example: the name of my
> table is myt, when I

BEGIN
> select *** from myt
> into *** where a = :new.a and b=:new.b;

EXCEPTION
    WHEN NO_DATA_FOUND
        --do whatever...
    WHEN OTHERS
        RAISE;
END;
>
> It is obviously that there is no data in the database at first, so no
> data can be selected and even
> when there is data in the database, sometimes no data fulfill the select
> criteria so no data is selected, the result is the trigger does not
> work. How to handle such situation? Thanks.
>
> Simon
Received on Thu Jun 03 1999 - 01:54:42 CDT