title: Oracle database on trigger fail rollback
body: <p>I want to create a trigger that execute on update of a table.</p>
  
  <p>in particular on update of a table i want to update another table via a trigger but if the trigger fails (REFERENTIAL INTEGRITY-- ENTITY INTEGRITY) i do not want to execute the update anymore.</p>
  
  <p>Any suggestion on how to perform this?</p>
  
  <p>Is it better to use a trigger or do it anagrammatically via a stored procedure?</p>
  
  <p>Thanks</p>