Re: ORA-00900: invalid SQL statement on CREATE TRIGGER
From: Kay Kanekowski <kay.kanekowski_at_web.de>
Date: Wed, 26 Apr 2017 01:31:20 -0700 (PDT)
Message-ID: <f178ee69-230a-486e-987f-f78e115f8303_at_googlegroups.com>
Date: Wed, 26 Apr 2017 01:31:20 -0700 (PDT)
Message-ID: <f178ee69-230a-486e-987f-f78e115f8303_at_googlegroups.com>
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
Received on Wed Apr 26 2017 - 10:31:20 CEST