title: EXCEPTION from stored procedure is not handling correctly.
body: <p>The SP EXCEPTION is not deleting the data that it should?</p>
  
  <pre><code>PROCEDURE TEST (TEST   IN  TABLE1.COLUMN1%TYPE, TEST2 IN  TABLE2.COLUMN1%TYPE)
  IS
  SEQ1 NUMBER;
  SEQ2 NUMBER;
  
  BEGIN
      SELECT seq_id.NEXTVAL INTO SEQ1 FROM DUAL;     
      INSERT INTO TABLE1 VALUES(SEQ1, TEST);
  
      SELECT seq_id2.NEXTVAL INTO SEQ2 FROM DUAL;
      INSERT INTO TABLE2 VALUES(SEQ2, TEST2);        
      COMMIT;
  EXCEPTION WHEN OTHERS THEN
      ROLLBACK;
      DELETE FROM TABLE1 WHERE COLUMN0 = SEQ1;
      DELETE FROM TABLE2 WHERE COLUMN0 = SEQ1;
      RAISE;
  END;
  </code></pre>
  
  <p>If an EXCEPTION occurrs, I want to delete everything from those tables that contains that certain ID. This SP is called X times, and I have 3 tables that have relation with a column. The first two calls are OK, if the third gives an error I want to delete those previous inserts too.</p>
  
  <pre><code>TABLES
  CALL TO SP  COLUMN1 - COLUMN2 - COLUMN3
  1           1         2         3
  2           1         2         3
  3           1         2         ERROR
  
  EXCEPTION
  Delete from TABLES WHERE COLUMN2 = 2; 
  </code></pre>