non-explainable SQL-Error

From: Peter Kroiß <pk_at_faw.uni-linz.ac.at>
Date: Mon, 10 Jan 2000 16:51:21 +0100
Message-ID: <3879FFF9.7FC9B932@faw.uni-linz.ac.at>

Sometimes an error occurs by using following statement, why? Normally this statement is ok, but sometimes I get the following error.

[SERVERERROR] Error from Server: ORA-00001: unique constraint (USER.XPKOBJEKT_KEYWORD) violated

INSERT INTO OBJEKT_KEYWORD(OBJEKT_NR, REIHUNG) SELECT 224183,1 FROM DUAL WHERE NOT EXISTS (SELECT OBJEKT_NR FROM OBJEKT_KEYWORD WHERE OBJEKT_NR=224183 AND REIHUNG=1) This statement inserts 2 values, but only if they are not allready in the table. Received on Mon Jan 10 2000 - 09:51:21 CST