title: How to handle unique constraint APEX - ORA-00001: unique constraint violation while updating interactive grid?
body: <p>I have a page with multiple interactive grid. In one of the interactive grid I have a add row button through which i am trying to add a row in the table but while doing so it is giving an error of violation of unique key constraint as follows:
  <strong>APEX - ORA-00001:unique constraint(MySchema.ConstraintName) violated ORA-02063:preceding line from FTDB for</strong>.</p>
  
  <p><a href="https://i.stack.imgur.com/Rb2Gr.png" rel="nofollow noreferrer">Interactive grid image:</a></p>
  
  <p>I have used the type:<strong>interactive grid- automatic row processing(DML)</strong> for saving the grid.  </p>
  
  <p><strong>NOTE</strong>:FTDB is a database link. I am using APEX 5.1</p>
  
  <p>Please let me know how to resolve this..</p>