oracle 12c
中我如下设置的触发器
CREATE OR REPLACE TRIGGER MY_TGR_1
BEFORE INSERT ON TAB_USER
FOR EACH ROW
DECLARE
NEXT_UUID NUMBER;
BEGIN
NEXT_UUID = 1;
:NEW.UUID := NEXT_UUID;
END;
表结构如下
执行插入语句后
INSERT INTO "test" ("name") VALUES ('chen');
报错
> ORA-04098: trigger 'test.TRI_TEST' is invalid and failed re-validation