Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01400

Re: ORA-01400

From: Gerard H. Pille <ghp_at_skynet.be>
Date: 10 Nov 1998 10:41:51 GMT
Message-ID: <01be0c97$9bb9e980$390120c0@GHP.creyfs.be>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US