Re: Q: Not Null constraints

You could make the offending column name part of the trigger exception message within a Form. From your question, however, I take it that you are not using forms for the data insertion?

BO/EBC/KX/RGFC Roger Bjaerevall 08-682 4851 (ebcrbj_at_ebcw150.ericsson.se) wrote:
: NOT NULL constraints can be named in the table definion.
 

: Is it possible to get the constraint name upon a request that
: inserts a NULL value into the column?
 

: Even if the constraint is named I'll get this message:
 

: ORA-01400: mandatory (NOT NULL) column is missing or NULL during insert
 

: Quite hard to find out which column that failed ;-)
 

: +------------------------------------------------------------------+
: + _/_/_/ _/_/_/ _/_/_/_/ Roger Bjärevall +
: + _/ _/ _/ _/ _/ BO/EBC/FL/RGFC +
: + _/ _/ _/ _/ _/ Ericsson Business Networks AB +
: + _/_/_/_/ _/_/_/_/ _/ 135 83 Tyresö +
: + _/ _/ _/ _/ _/ _/ Sweden +
: + _/ _/ _/ _/ _/ _/ +46 8 6824851 +
: + _/ _/ _/_/_/ _/_/ email: ebcrbj_at_ebc.ericsson.se +
: +------------------------------------------------------------------+

--
=================================================================
Gary T. Smith                | My opinions are strictly my own.
smithg2_at_iia.org              |
=================================================================