请大侠指点下，我的ORACLE创建触发器没反应呢

SQL> create table scott.logon(
2 id number(4) not null primary key,
3 name varchar(10),
4 password varchar(20));

Table created

SQL> create sequence logon_sequence
2 increment by 1
3 start with 1
4 nomaxvalue
5 nocycle
6 cache 10;

Sequence created

SQL> create trigger logon_tg before insert on scott.logon
2 for each row
3 begin
4 select logon_sequence.nextval into:new.id from dual;
5 end;
6 commit;
7

---

触发器中不能commit 除非使用自治事务

---

问题时你这触发器中的查询语句在执行时输出到哪儿呢?控制台>

---

做个标记。
这里的触发器应该用after吧，但会提示ORA-04084:cannot change NEW values for this trigger type。期待高手解决

---

我测试了一下，除了commit; 没有问题
insert into logon(name) values('aaa');
insert into logon(name) values('aaa');
insert into logon(name) values('bbb');

select * from logon
/

ID NAME PASSWORD
----- ---------- --------------------
1 aaa
2 aaa
3 bbb

---

引用

我测试了一下，除了commit; 没有问题
insert into logon(name) values('aaa');
insert into logon(name) values('aaa');
insert into logon(name) values('bbb');

select * from logon
/

  ID NAME      PASSWORD
----- ---------- ------