NULL during insert

From: BO/EBC/KX/RGFC Roger Bjaerevall 08-682 4851 <ebcrbj_at_ebcw150.ericsson.se>
Date: Tue, 31 May 1994 11:35:25 GMT
Message-ID: <1994May31.113525.9536_at_ericsson.se>


Is it possible to get the actual column name or constraint name for the following exception:

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

It is *quite* difficult to find out which column that contained NULLS during insert with the above message as a hint... and the table might contain up to 250 columns.

I'm getting this in a C++ application using OCI as the Oracle interface.

+------------------------------------------------------------------+

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

+------------------------------------------------------------------+
Received on Tue May 31 1994 - 13:35:25 CEST

Original text of this message