Unique Key Constraint Violated

[Sridevi Sangaiah]

Hi All,

I am getting the following error when i try to insert a record into the database:

"Unique Key Constraint [<SchemaName>.<PrimaryKery Constraint for the table>] violated"

The primary key for the table in which i try to insert a record is generated using Sequences in ORACLE. So i am not able to get why still the constraint is violated

[Francis Siu]

hi Sridevi Sangaiah

could you type the code of Sequences here?

Please try to check the attribute of primary key which contains reference to other foreign key that contain unique key constraint or not.

[Avi Abrami]

Sridevi,
Use

sequence.NEXTVAL

and not

sequence.CURRVAL

Perhaps the sequence value is clashing with a manually supplied value?
Perhaps the sequence has reached its maximum value?

Good Luck,
Avi.