sql trigger not working/ERROR ORA-00911

Question

have problem with sql trigger:

CREATE TRIGGER trigger_zapujceni
AFTER INSERT
ON VYPUJCIT
FOR EACH ROW
BEGIN
UPDATE TITUL t
set t.POCET_AKTUALNE = t.POCET_AKTUALNE – 1
where t.ID_TITUL = :new.ID_TITUL;
END;

where line AFTER INSERT says ERROR: SQL Statement Ignored and line ON VYPUJCIT says: ORA-00911: Invalid character

does anyone knows and solution? Thanks a lot, I am not a sql master

Answer 1

Your minus sign is some Unicode character but no "regular" minus sign.

db<>fiddle

Just replace the Unicode minus sign with a "regular" one and your trigger will be OK.