Java code for creating an auto-increment field by oracle sequence trigger -- create table TEST (id number (9), name varchar (30 )) -- create squence create sequence TEST_SEQUENCE minvalue 0 maxvalue 999999999999999999999999999 start with 4 increment by 1 nocache; -- create trigger create or replace trigger I _TEST_ID before insert on TEST for each row begin select TEST_SEQUENCE.nextval into: new. ID from dual; end; -- TEST insert into TEST (NAME) values ('asd ') encountered a problem during this process trigger validation did not query SELECT do using statements through the ora-04098. OBJECT_NAME, do. status FROM dba_objects doWHERE do. OBJECT_TYPE = 'trigger' found that the TRIGGER is invalid so go to see the TRIGGER code after compilation error prompt for pls-00103: the reason for the occurrence of the symbol "" may be that you have modified the full-width characters or spaces in your statement, and you can run the OK command.