newbie question on triggers
From: Jim Lyons <godzilla_at_seuss.cc.utexas.edu>
Date: 1995/10/11
Message-ID: <1995Oct11.165501_at_seuss.cc.utexas.edu>#1/1
Date: 1995/10/11
Message-ID: <1995Oct11.165501_at_seuss.cc.utexas.edu>#1/1
- I have a table in which some columns have the "not null" clause.
- I have written an insert trigger which is to be fired -before- insertion.
- I have code in my trigger to test the not-null columns and, if the user has not provided data, write a message saying specifically which required field was omitted (or, at least, the first detected).
- Yet, when I insert data into that table, with null values in the required field, I get the Oracle error message and my trigger is not fired at all.
Is there any way I can do this?
-- Jim Lyons | Operating Systems Specialist Computation Center | 512-475-9331 University of Texas at Austin | godzilla_at_seuss.cc.utexas.edu http://www.cc.utexas.edu/~godzilla/jimlyons.htmlReceived on Wed Oct 11 1995 - 00:00:00 CET