ODBC

I

Indra

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
 
J

Joshua A. Booker

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC - Connecting MS Access to Oracle 10g 0
Multiple ODBC Queries 2
Capture ID of newly inserted row 3
ODBC upate on a linked table failed 2
On 64bit MS2003 server we cannot get MS-Office to conn with ODBC 0
Append Records to ORACLE via ODBC 0
Appending records: 2 ADO connections 1
How do I capture content of an ODBC error message from Oracle? 3

Top