CREATE OR REPLACE TRIGGER TRIG_ID
BEFORE INSERT
ON TRIG_TEST
FOR EACH ROW
begin
select order_id.nextval into :new.order_id from dual;
end;
BEFORE INSERT
ON TRIG_TEST
FOR EACH ROW
begin
select order_id.nextval into :new.order_id from dual;
end;
begin
select order_id.nextval into :new.test_id from dual;
end;
问题已自己解决,
原因是:select order_id.nextval into :new.test_id from dual;中test.id必须是表中的列名,而不应是序列名谢谢welyngj(平平淡淡)参与,奖励20分,自己留80分,哈,,,
那就全给 welyngj(平平淡淡) 吧!