title: ORA 000001 Unique constraint violated
body: <p>I have an Insert statement to a table which has a primary key of dep_id and emp_id. My java program generates a new emp_id for a new record and inserts it. What is happening is if for example, I have dep_id = 100 and emp_id = 25, I am not able to insert a record where dep_id = 100 and emp_id = 26, but I can for dep_id = 100 and emp_id = 27. I checked thru select statements if something of that combination (dep_id = 100 and emp_id = 26) exists. There is nothing of that sort. I still did a 
          DELETE from where dep_id = 100 and emp_id = 26 and Commit
  just to be sure and then tried to insert, but still it does not work. What might be wrong? Follwing is the code:  Modified DDL and Insert statement(Obtained from Eclipse console)  </p>
  
  <pre><code>                                                                                    CREATE  TABLE "TestDB"."table1" 
   (  "dep_id" NUMBER(20,0), 
  "emp_id" NUMBER(20,0), 
  "STATUS" VARCHAR2(10 BYTE), 
  "PRO_LEVEL" VARCHAR2(14 BYTE), 
  "new_sql_stmt" VARCHAR2(4000 BYTE), 
  "DEL_TEM" VARCHAR2(500 BYTE), 
  "tab_name" VARCHAR2(4000 BYTE), 
  "COL_NAME" VARCHAR2(4000 BYTE), 
  "QUERY_TYPE" VARCHAR2(4000 BYTE), 
  "NAME" VARCHAR2(4000 BYTE), 
  "DT_MODIFIED" DATE DEFAULT SYSDATE
  </code></pre>
  
  <p>) </p>
  
  <pre><code>  CREATE UNIQUE INDEX "TestDB"."table1_PK" ON "TestDB"."table1" ("dep_id", "emp_id") 
  
  
       INSERT into table1            (dep_id,emp_id,status,new_sql_stmt,tab_name,col_name,query_type,NAME)values('100','26','Unlock','INSERT into testTab(id_some,nm_some,id_some_origin,flag,some_code,author,order) values  (''S11111111'',''trialSome00'','''',''y'','''',''100'',0)','testTab','nm_some','INSERT','trialSome00')
  </code></pre>
  
  <p>Please note that the Insert statement itself has another Insert statement as the value. This Insert statement(The main one) is used in many other places in the app. Also, The dep_id that I use 100 is a test dep_id. Nobody uses it but me.</p>