Xref: alice comp.databases.oracle.server:19451
Path: alice!news-feed.fnsi.net!ais.net!newspeer.monmouth.com!demos!news1.spb.su!news.nevalink.ru!news.wplus.spb.ru!nam!128.1.2.45
From: "Maxim V. Krapivin" <baltros@mail.wplus.net>
Newsgroups: comp.databases.oracle.server
Subject: Re: ORA-1400 - mandatory (NOT NULL) column is missing or NULL during insert
Date: Wed, 22 Apr 1998 15:36:52 +0400
Organization: BALTROS
Lines: 17
Message-ID: <353dd648.0@nam>
References: <6gsgsf$6hu$1@news.wplus.spb.ru>
X-Newsreader: Microsoft Outlook Express 4.71.1712.3
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4

Oleg Mineev wrote :
>ORA-1400 - mandatory (NOT NULL) column is missing or NULL during insert
>How I can get the failed constraint name ?


Try to execute following query :

SELECT constraint_name, search_condition
     FROM  SYS.ALL_CONSTRAINTS
    WHERE table_name = UPPER('my_table_name')

This query retrieves the names of all constraints for specified table,
including constraints for NOT NULL columns.

Maxim. maximka_kr@usa.net