title: oracle - integrity constraint violated - child record found
body: <p>I have a huge pl/sql stored procedure, where we make some deletions as long as insertions.
  Procedure starts with the statement</p>
  
  <pre><code> EXECUTE IMMEDIATE 'SET CONSTRAINTS ALL DEFERRED'
  </code></pre>
  
  <p>And at the last <code>commit</code> statement I receive ORA-02292: integrity constraint AAA violated. 
  The questions is that I don't know which statement exactly causes it, because I have both deletion from parent table (before child one) and insertions into child table before parent. 
  I tried to google it, but everywhere it's said that 02292 happens when I try to delete only.</p>
  
  <p>Could this error happen when I try to insert value in the child table but there is no this entry in the parent?</p>
  
  <p>Also, what is the difference between 02292 and 02291? </p>