Re: unique constraint error

From: Cel <cefernan_at_capgemini.fr>
Date: Mon, 22 Jul 2002 10:21:28 +0200
Message-ID: <ahgfas$f6q$1_at_s1.read.news.oleane.net>


00001, 00000, "unique constraint (%s.%s) violated" // *Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.

//         For Trusted Oracle configured in DBMS MAC mode, you may see
//         this message if a duplicate entry exists at a different level.
// *Action: Either remove the unique restriction or do not insert the key.


"Cel" <cefernan_at_capgemini.fr> a écrit dans le message news: ah9br9$nuh$1_at_s1.read.news.oleane.net...
> I have a table A :
>
> CREATE TABLE A (
> column1 VARCHAR2 (2) NOT NULL, column2 VARCHAR2 (4) NOT NULL, column3
> VARCHAR2 (2) NOT NULL,
>
> column4 VARCHAR2 (6) NOT NULL, column5 CHAR (8) NOT NULL, column6 CHAR
(8),
>
> column7 CHAR (1), column8 CHAR (1))
>
> There are 5 index on the first 5 columns:
> CREATE UNIQUE A_IU ON "SCHEMA".A(column1 , column2 , column3 , column4 ,
> column5 )
>
> TABLESPACE IDX_APP_A PCTFREE 5 STORAGE(INITIAL 16384 NEXT 8192 PCTINCREASE
> 0 ) ;
>
> I have a stored procedure which does either an INSERT :
>
> INSERT INTO A ( column1 , column2 , column3 , column4 , column5 ,
column6
> , column7 , column8 )
> VALUES ( val1, val2, val3, val4, val5, val6, NULL, NULL , NULL);
>
> or an UPDATE :
> UPDATE A SET column6 = val11 AND column3 = val3 AND column4 = val4;
>
> Of course if the record already exists in the table,
> it raises a unique constraint error.
>
> How do i do to avoid this error ?
> thanks for your help
>
>
>
>
>
Received on Mon Jul 22 2002 - 10:21:28 CEST

Original text of this message