ORA-00900: invalid SQL statement on CREATE TRIGGER

[Joe Seeley]

I'm trying to create a before insert or update trigger that would update a timestamp any time an update is made to a table. The following is my query, but this is giving an invalid SQL statement error.

CREATE OR REPLACE TRIGGER "SCHEMA".TRIGGER_NAME"
BEFORE INSERT OR UPDATE ON SCHEMA.TABLENAME
FOR EACH ROW
BEGIN
:new.LASTMODIFIED := sysdate;
END;
/

[Kay Kanekowski]

Hi Joe,
is this only a typo here "SCHEMA".TRIGGER_NAME" - there is missing " before TRIGGER_NAME.

i do this and it works:

create table kk1 ( wert number, LASTMODIFIED date, lastuser varchar2(100));

CREATE OR REPLACE TRIGGER scott.T1
BEFORE INSERT OR UPDATE ON scott.kk1
FOR EACH ROW
BEGIN
:new.LASTMODIFIED := sysdate;
:new.LASTUSER := user;
END;
/

regards
Kay