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 2
Access frontend with SQL Server backend: my solution for ODBC Call error 1
Capture ID of newly inserted row 3
How do I capture content of an ODBC error message from Oracle? 3
ODBC upate on a linked table failed 2
ODBC oracle link 5
[oracle][odbc][ora]ORA-00942: table or view does not exist (#942) 1
All fields in record marked as #DELETED 1

Top