Oracle 18c

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

create table transaction_type (id number, label varchar2(30));
create table transaction_type_log_history (id number, action varchar2(30));
CREATE TRIGGER transaction_type_af_insert
AFTER INSERT ON transaction_type
FOR EACH ROW
DECLARE
  type varchar(30)
  action varchar(30)
BEGIN
  UPDATE transaction_type_log_history
  SET action = 'After_Insert_transaction_type'
  WHERE transaction_type.id = transaction_type_log_history.id;
END;
/
ORA-24344: success with compilation error

select * from user_errors;


NAME
TYPE
SEQUENCE
LINE
POSITION
TEXT
ATTRIBUTE
MESSAGE_NUMBER


TRANSACTION_TYPE_AF_INSERT
TRIGGER
1
2
15
PLS-00103: Encountered the symbol "(" when expecting one of the following:

   ; is default authid as force under accessible

ERROR
103


CREATE OR REPLACE TRIGGER transaction_type_af_insert
AFTER INSERT ON transaction_type
FOR EACH ROW
DECLARE
  l_type varchar2(30)
  l_action varchar2(30)
BEGIN
  UPDATE transaction_type_log_history
  SET action = 'After_Insert_transaction_type'
  WHERE transaction_type.id = transaction_type_log_history.id;
END;
/
ORA-24344: success with compilation error

select * from user_errors;


NAME
TYPE
SEQUENCE
LINE
POSITION
TEXT
ATTRIBUTE
MESSAGE_NUMBER


TRANSACTION_TYPE_AF_INSERT
TRIGGER
1
3
3
PLS-00103: Encountered the symbol "L_ACTION" when expecting one of the following:

   := ; not null default character

ERROR
103


CREATE OR REPLACE TRIGGER transaction_type_af_insert
AFTER INSERT ON transaction_type
FOR EACH ROW
DECLARE
  l_type varchar2(30);
  l_action varchar2(30);
BEGIN
  UPDATE transaction_type_log_history
  SET action = 'After_Insert_transaction_type'
  WHERE transaction_type.id = transaction_type_log_history.id;
END;
/
ORA-24344: success with compilation error

select * from user_errors;


NAME
TYPE
SEQUENCE
LINE
POSITION
TEXT
ATTRIBUTE
MESSAGE_NUMBER


TRANSACTION_TYPE_AF_INSERT
TRIGGER
1
7
9
PL/SQL: ORA-00904: "TRANSACTION_TYPE"."ID": invalid identifier
ERROR
0

TRANSACTION_TYPE_AF_INSERT
TRIGGER
2
5
3
PL/SQL: SQL Statement ignored
ERROR
0


CREATE OR REPLACE TRIGGER transaction_type_af_insert
AFTER INSERT ON transaction_type
FOR EACH ROW
DECLARE
  l_type varchar2(30);
  l_action varchar2(30);
BEGIN
  UPDATE transaction_type_log_history
  SET action = 'After_Insert_transaction_type'
  WHERE transaction_type_log_history.id = :new.id;
END;
/

NAME	TYPE	SEQUENCE	LINE	POSITION	TEXT	ATTRIBUTE	MESSAGE_NUMBER
TRANSACTION_TYPE_AF_INSERT	TRIGGER	1	7	9	PL/SQL: ORA-00904: "TRANSACTION_TYPE"."ID": invalid identifier	ERROR	0
TRANSACTION_TYPE_AF_INSERT	TRIGGER	2	5	3	PL/SQL: SQL Statement ignored	ERROR	0