Re: Primary Keys And NULL Values

Sorry for mis-reading your post, and subjecting you to that diatribe on foreign keys ;-).

Yes it would be nice, and no I cant help.

Andrew Pejta

> I thought I made my point clear but....
>
> I am not trying to insert NULL's. I'm just trying to provide a better
>
> error message than the generic error "ORA-01400: mandatory (NOT NULL)
> column is missing or NULL during insert" if someone else does. This
> error
> can be for any column that someone has defined the NOT NULL constraint
>
> improperly ("field1 number not null" or "field2 number constraint
> field2_nn not null") and/or the primary key.
>
> Wouldn't it be nice if we could get the more specific error
> "ORA-02290: check constraint (SCHEMA.CONSTRAINT_NAME) violated"
> instead.
>
Received on Wed Feb 25 1998 - 00:00:00 CST