ORA-00900: invalid SQL statement on CREATE TRIGGER

From: Joe Seeley <joiey.seeley_at_gmail.com>
Date: Tue, 25 Apr 2017 10:22:20 -0700 (PDT)
Message-ID: <993d0e9a-f337-4ec8-8928-bd877fbea15b_at_googlegroups.com>



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
[Quoted]         :new.LASTMODIFIED := sysdate; END;
/ Received on Tue Apr 25 2017 - 19:22:20 CEST

Original text of this message