unique constraint error

CREATE TABLE A (
[Quoted] [Quoted] column1 VARCHAR2 (2) NOT NULL, column2 VARCHAR2 (4) NOT NULL, column3 VARCHAR2 (2) NOT NULL, [Quoted] column4 VARCHAR2 (6) NOT NULL, column5 CHAR (8) NOT NULL, column6 CHAR (8),

[Quoted] column7 CHAR (1), column8 CHAR (1))

[Quoted] [Quoted] There are 5 index on the first 5 columns: [Quoted] [Quoted] CREATE UNIQUE A_IU ON "SCHEMA".A(column1 , column2 , column3 , column4 , column5 )

[Quoted] TABLESPACE IDX_APP_A PCTFREE 5 STORAGE(INITIAL 16384 NEXT 8192 PCTINCREASE 0 ) ;

[Quoted] [Quoted] I have a stored procedure which does either an INSERT :

[Quoted] [Quoted] INSERT INTO A ( column1 , column2 , column3 , column4 , column5 , column6 [Quoted] , column7 , column8 )

[Quoted] [Quoted]    VALUES ( val1, val2, val3, val4, val5, val6, NULL, NULL , NULL);

[Quoted] or an UPDATE :
[Quoted] [Quoted] UPDATE A SET column6 = val11 AND column3 = val3 AND column4 = val4;

[Quoted] [Quoted] 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 Fri Jul 19 2002 - 17:39:12 CEST