title: Trigger that insert into a dblink table
body: <p>I am trying to do a trigger, that select values into some tables, and then insert them into another table.</p>
  
  <p>So, for now I got this. There is a lot of columns, so I don't copy them, it is only varchar2 values, and this part works, so I don't think it is useful : </p>
  
  <pre><code>   create or replace 
  TRIGGER TRIGGER_FICHE 
  AFTER INSERT ON T_AG 
  
  BEGIN
    declare 
    begin
  
  
  INSERT INTO t_ag_hab@DBLINK_DEV
  ()
  values
  ();
  
  /*commit;*/
  end;
  END;
  </code></pre>
  
  <p>Stored procedure where trigger will be called(again a lot of parameters, not relevant to copy them : </p>
  
  <pre><code>INSERT INTO T_AG()
         VALUES
                    ();
  
  
  commit work;
  </code></pre>
  
  <p>The thing is, we cannot do commit into a trigger, I read that, and understand it.</p>
  
  <p>But, how can I see an update of my table, with the new value?</p>
  
  <p>When the process is runnign, there is nor error, but I don't see the new line into t_ag_hab.</p>
  
  <p>I know it's not very clear, but I don't know how to explain it other way.
  How can I fix this?,</p>