ORA-04098: ORA-04098: trigger 'USER_TRIGGER'is invalid and failed re-valid
代码:
create table t_user(
user_id int primary key,
user_name varchar(30),
credits int,
u_password varchar(32),
last_visit date,
last_ip varchar(23)
);
CREATE SEQUENCE user_id_seq INCREMENT BY 1 START WITH 1;
CREATE TRIGGER TRG_USER
BEFORE INSERT ON T_USER
FOR EACH ROW
BEGIN
INSERT INTO T_USER(USER_ID)
VALUES(USER_ID_SEQ.NEXTVAL);
END;
INSERT INTO T_USER(USER_NAME,U_PASSWORD) VALUES('admin','123456');