title: Create a trigger to update time stamp on inserted or updated records?
body: <p>I am trying to create an Oracle trigger that would update <code>entry_stamp</code> column (type=<code>DATE</code>) on every inserted or updated record for a certain table. Here is my script:</p>
  
  <pre><code>CREATE OR REPLACE TRIGGER mytable_entry_stamp 
  AFTER INSERT OR UPDATE ON mytable FOR EACH ROW
  BEGIN :NEW.entry_stamp := SYSDATE; END;
  </code></pre>
  
  <p>I am getting this error:</p>
  
  <blockquote>
    <p>ORA-04084: cannot change NEW values for this trigger type</p>
  </blockquote>