Q: Not Null constraints

From: BO/EBC/KX/RGFC Roger Bjaerevall 08-682 4851 <ebcrbj_at_ebcw150.ericsson.se>
Date: Thu, 4 Aug 1994 12:00:10 GMT
Message-ID: <1994Aug4.120010.15509_at_ericsson.se>


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 +

+------------------------------------------------------------------+
Received on Thu Aug 04 1994 - 14:00:10 CEST

Original text of this message