oracle自增auto_increment与oracle 创建触发器是非法的 ORA-04098: trigger 'USER_TRIGGER'is invalid and failed re-v

来源：互联网发布：有哪些经济数据库编辑：程序博客网时间：2024/06/15 21:28

RA-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');

//解决方法(本人测试通过)

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) );  --建立一个sequence序列  CREATE SEQUENCE USER_ID_SEQ INCREMENT BY 1 START WITH 1; --建立一个触发器:  CREATE OR REPLACE TRIGGER TRG_USER   BEFORE INSERT ON T_USER     FOR EACH ROW BEGIN   SELECT USER_ID_SEQ.NEXTVAL INTO :NEW.USER_ID FROM DUAL; END TR_FCBOOK;  INSERT INTO T_USER(USER_NAME,U_PASSWORD) VALUES('ADMIN','123456');          --DROP TABLE T_USER; --DROP SEQUENCE USER_ID_SEQ; --DROP TRIGGER TRG_USER;