title: ORA-04098 is invalid and failed re-validation
body: <p>I wrote the below trigger and it was compiled successfully.</p>
  
  <pre><code>create or replace trigger after_update_datetable
  after update on date_table
  for each row
  begin
     if(TRUNC(:new.end_date) - TRUNC(:new.start_date) &gt; 90) THEN
      UPDATE date_table set END_DATE = :old.END_DATE, START_DATE =  :old.START_DATE;
     END IF;
  END;
  </code></pre>
  
  <p>However when I performed the below update statement I got this error</p>
  
  <p>update date_table set end_date = sysdate, start_date = sysdate-100;</p>
  
  <p>trigger failed -ORA-04098 is invalid and failed re-validation. </p>
  
  <p>Any help is appreciated. Thanks</p>