Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table tab1 (id int, doc clob)
create table tab2 (id int, doc clob, name varchar2(8))
create table tab3 (refname char(2), name varchar2(8))
insert into tab3 values ('A1', 'Name A1')
1 rows affected

create or replace procedure proc (id int, doc clob) is
begin
    insert into tab2 
        select id, doc, name 
        from tab3 where refname = 'A1'; 
    dbms_output.put_line (sql%rowcount||' row into tab2 inserted.'); 
end;
/
create or replace trigger tr_example
after insert on TAB1 for each row
declare
begin 
    proc (:new.id, :new.doc);
end;
/
begin 
    dbms_output.enable;
    insert into tab1 values (1, 'document');
end;
/
1 rows affected

dbms_output:
1 row into tab2 inserted.

select * from tab2


ID
DOC
NAME


1
document
Name A1