博客

Error updating database. Cause: java.sql.SQLSyntaxErrorException: ORA-02289: 序列不存在

Error updating database. Cause: java.sql.SQLSyntaxErrorException: ORA-04098: 触发器 ‘USER.TRI_T_WEBLOG’ 无效且未通过重新验证

--新建序列--
create sequence T_LQQX_SEQUENCE
start with 1
increment by 1
nominvalue
maxvalue 999999
nocycle
noorder
cache 100;
--新建触发器--
CREATE OR REPLACE TRIGGER tri_t_lqqx
before insert on t_lqqx
for each row 
when(new.id is null)
begin
SELECT t_lqqx_sequence.Nextval into:new.id from dual;
end;