Re: Help with Ora01400 exception

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/04/11
Message-ID: <3350a5a6.7608340_at_newshost>#1/1

On Thu, 10 Apr 1997 14:03:01 -0700, aso2_at_po-box.mcgill.ca wrote:

>We've been having trouble finding out what an ora01400 exception is.
>This class of errors (ie ora)doesn't seem to be in any of the
>documentation. Can someone tell us what this means, or point us to a
>site which might help?
>
>Thanx,
>Adrian

in unix

$ oerr ora 1400

01400, 00000, "mandatory (NOT NULL) column is missing or NULL during insert"
// *Cause:
// *Action:  

In any environment with pl/sql:

SQL> exec dbms_output.put_line( sqlerrm( -1400 ) ); ORA-01400: mandatory (NOT NULL) column is missing or NULL during insert  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD

http://govt.us.oracle.com/ -- downloadable utilities

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Apr 11 1997 - 00:00:00 CEST