ODBC

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Indra - 21 May 2008 14:18 GMT

I am inserting new record into ORACLE DB. Whenever I add the record
the Unique Constraint violation message is displayed. "ODBC Call failed
[ORACLE][ODBC][ORA]ORA-00001: Unique constraint(MGR.TRACKHD_PK) violated"

An append query is used to insert the record from event trigger and
record however is getting added/insterted into the ORACLE DB.

I am using ODBC drivers version 9.2 but this message is holding
users back. Any advice will be appreicated.

Thanks
Indra

Reply to this Message

Joshua A. Booker - 21 May 2008 17:37 GMT

Indra,

The values that you are trying to add to the oracle table 'MGR' are allready
in the table for the field(s) associated woth the unique constraint called
TRACKHD_PK.

You should determine the field(s) in the primary key of the oracle table and
make sure you are inserting unique values.

HTH,
Josh

> I am inserting new record into ORACLE DB. Whenever I add the
> record
[quoted text clipped - 9 lines]
> Thanks
> Indra

Reply to this Message