title: ORA-00001: unique constraint (DEV.X_PK) violated
body: <p>I have a java code that sends data to a web service, and a portlet that uses that data. </p>
  
  <p>Data sent by java agent gets placed in TMP table, and merge procedure merges it into MAIN table used by portlet.</p>
  
  <p>When running java agent I get the following error, although I ensure that no duplicate primary keys are sent:</p>
  
  <pre><code>ORA-00001: unique constraint (DEV.X_PK) violated
  ORA-06512: at "DEV.PGK_Y", line 200
  ORA-06512: at line 1
  </code></pre>
  
  <p>I tried turning off primary key constraint, but in vain. Then I tried to drop all tables used, and created them again. But still no luck...</p>
  
  <p>Interestingly, I am able to manually insert data into TMP and run merge procedure, and there are no errors.</p>
  
  <p>Any help is appreciated...</p>