oracle ora04098,oracle自增auto_increment与oracle 创建触发器是非法的 ORA-04098: trigger 'USER_TRIGGER'is invalid ...

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 TABLET_USER(USER_ID INT PRIMARY KEY,USER_NAME VARCHAR(30),

CREDITSINT,

U_PASSWORDVARCHAR(32),

LAST_VISIT DATE,

LAST_IPVARCHAR(23)

);

--建立一个sequence序列CREATE SEQUENCE USER_ID_SEQ INCREMENT BY 1 START WITH 1;

--建立一个触发器:CREATE OR REPLACE TRIGGERTRG_USER

BEFOREINSERT ONT_USERFOREACH ROWBEGIN

SELECT USER_ID_SEQ.NEXTVAL INTO :NEW.USER_ID FROMDUAL;ENDTR_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;