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

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Zoran_Dimov
Forum Newbie
Posts: 16
Joined: Wed Jun 21, 2006 6:10 pm
Location: Macedonia
Contact:

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

Post 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!
Post Reply