create or replace trigger trg_name
  before insert on table1
  for each row
begin
  insert into table2
    (id,
     phone,
     text,
     timesend)
  values
    ('',
     :new.phone,
     :new.text,
     :new.timesend);
end;

create or replace procedure SMS_GATE is
begin
  for rec1 in (select *
                 from table2 t2
                where to_date(t2.timesend, 'YYYYMMDDHH24MISS') > (select max(to_date(t1.timesend, 'YYYYMMDDHH24MISS')) from table1 t1)) --получаем все новые записи, которых нет в table1
  loop
    insert into table1
      (id,
       phone,
       text,
       timesend)
    values
      ('',
       rec1.phone,
       rec1.text,
       TO_CHAR(sysdate, 'YYYYMMDDHH24MISS'));
  end loop;
  commit;
end SMS_GATE;