title: Non-Updating column in trigger
body: <p>My issue is that the trigger detailed below seems to execute correctly except for the fact that the update statement  <code>UPDATE my_dblist
      SET passive_servername = v_newpassive WHERE server = :NEW.server AND dbname = :NEW.dbname;</code> does not seem to happen. The old record is deleted and inserted into history correctly but the new record does not have the old active server listed under passive_servername. I have a feeling this might have something to do with it being autonomous?</p>
  
  <pre><code>create or replace
  TRIGGER cluster_check
  AFTER INSERT ON my_dblist
  FOR EACH ROW
  DECLARE
  pragma autonomous_transaction;
  v_duplicates NUMBER;
  v_newpassive varchar2(30);
  BEGIN
  SELECT count(*) INTO v_duplicates FROM my_dblist WHERE passive_servername         = :new.server and dbname = :new.dbname order by 1;
  IF v_duplicates &gt; 0
  THEN 
  SELECT server INTO v_newpassive FROM my_dblist WHERE passive_servername = :NEW.server AND dbname = :NEW.dbname ORDER BY 1;
  UPDATE my_dblist
  SET passive_servername = v_newpassive WHERE server = :NEW.server AND dbname = :NEW.dbname;
  INSERT INTO my_dblist_history 
  SELECT * FROM my_dblist WHERE passive_Servername = :NEW.server AND dbname = :NEW.dbname;
  DELETE FROM my_dblist 
  WHERE passive_Servername = :NEW.server AND dbname = :NEW.dbname;
  END IF;
  commit;
  END;
  </code></pre>