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

When you create your table. also create separate NOT NULL constraints for the columns. In other words, go ahead and create the table with columns as NOT NULL, but also ALTER TABLE ADD CONSTRAINT ... and create a separate named NOT NULL constraint. Then, when you perform the same insert action, Oracle will tell you the exact column for which the error is occurring.

HTH & HAND Alan Vervaeke.

Oleg Mineev wrote in message <6gsgsf$6hu$1_at_news.wplus.spb.ru>...
>How I can get the failed constraint name ?
>
>Thx.
>
>Oleg
>
>
>
>
Received on Mon Apr 13 1998 - 12:12:43 CDT