Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help with Ora01400 exception
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