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

From: Rachel Carmichael <rachel.carmichael_at_citicorp.com>
Date: Mon, 13 Apr 1998 07:53:42 -0400
Message-ID: <3531FCC5.809D31B6@citicorp.com>

look in dba_constraints (or user_constraints) and select by table_name and owner for the constraints on that table... this will give you the list of ALL constraints, but you can then look in dba_cons_columns to see which columns are involved.

Rachel

Oleg Mineev wrote:

> How I can get the failed constraint name ?
>
> Thx.
>
> Oleg
Received on Mon Apr 13 1998 - 06:53:42 CDT

This message: [ Message body ]
Next message: Eric J. Stoffer: "Web App Server Transaction Setup"
Previous message: Rachel Carmichael: "Re: Switching on SERVEROUTPUT in a stored procedure"
In reply to: Oleg Mineev: "ORA-1400 - mandatory (NOT NULL) column is missing or NULL during insert"
Next in thread: George Meltser: "Re: ORA-1400 - mandatory (NOT NULL) column is missing or NULL during insert"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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