drop table t_work@
drop table t_temp@
drop table t_info@

create table t_work(id number(10), text varchar2(20))@
create table t_temp(id number(10), text varchar2(20))@
create table t_info(id number(10), text varchar2(20))@

create or replace procedure p_ins() 
specific p_ins
language sql
begin 
    insert into t_temp values (300, 'text300');
end@

create or replace procedure p_read()
specific p_read
language sql
begin
    insert into t_info (select id, text from t_temp);
end@

drop trigger t_work_trg_aft_upd@

create trigger t_work_trg_aft_upd
after update on t_work 
for each statement
begin atomic
  call p_read;
end@

begin atomic
    call p_ins;
---
-- много чего ---
---
    update t_work set text='text';
end@