[ODBC driver for Oracle][Oracle]ORA-00001: unique ..??
Posted: Thu Jul 06, 2006 8:18 am
[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!
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!