Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01400
Give all your constraints a name, even the "not null" and "check".
--
Kind Regards,
Gerard
Pavel I Babachanakh <uxid_at_artintel.cherkassy.ua> wrote in article
<728ou2$msq$3_at_whale.gu.net>...
> Hi, ALL!
>
> When I INSERT the data into the table which has several
> columns with NOT NULL constraint, I get the following error
> message:
>
> ORA-01400: mandatory (NOT NULL) column is missing or NULL during insert
>
> How can I learn which column has NULL value?
>
> Pavel
> uxid_at_artintel.cherkassy.ua
>
>
>
>
Received on Tue Nov 10 1998 - 04:41:51 CST