Re: no row, but index violated when insert

> i've got a problem. i'm trying to insert a new record into a table
> thru form. transaction fails but no message appears. i know it cos
> it returns *zero* row when i count (*) from the targeted table in
> sql+. ok. i try to insert the new record in sql+ and it ends up
> with a message telling me that the action has violated the unique
> index of the table.
>
> can anyone tell me what's happening? and more important, how to
> handle it? as far as i know, i'm the only one who is working with
> that table. i don't think i can drop the table and rebuild it -
> cos that's an interface table in Oracle Order Entry... :(

Sounds to me like a violation of a foreign key or check constraint. Take a good look at user_constraints and see if there are any constraints on the table. Then look at the tables referenced and see if the required values exist.

Daniel A. Morgan Received on Thu Nov 26 1998 - 00:00:00 CET