From: smithg2@iia.org (Gary Smith)
Newsgroups: comp.databases.oracle
Subject: Re: Q: Not Null constraints
Date: 8 Aug 1994 16:50:39 GMT
Organization: International Internet Association.
Lines: 34
Message-ID: <325nov$kjt@ankh.iia.org>
References: <1994Aug4.120010.15509@ericsson.se>
NNTP-Posting-Host: mary.iia.org
X-Newsreader: TIN [version 1.2 PL2]


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@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@ebc.ericsson.se +
: +------------------------------------------------------------------+


--
=================================================================
Gary T. Smith                | My opinions are strictly my own.
smithg2@iia.org              |
=================================================================