Page 1 of 1

[ODBC driver for Oracle][Oracle]ORA-00001: unique ..??

Posted: Thu Jul 06, 2006 8:18 am
by Zoran_Dimov
[Microsoft][ODBC driver for Oracle][Oracle]ORA-00001: unique constraint (WEBSHOP.SYS_C002282) violated.

I am getting this ODBC error message when i try to excecute the SQL query

"INSERT INTO Special_Offers VALUES(1,'banner_relax50.gif')";


The table Special_Offers is created with the query

CREATE TABLE Special_Offers
(
PR_CODE NUMBER(4) NOT NULL,
OFFER VARCHAR2(30),
Primary key (PR_CODE)
)

I Googled this problem, but all it says is that my table contains UNIQUE value

Thank in advance!