create or replace trigger tr_tai_ologrec_serial_i before insert on tai_ologrec
for each row
declare
-- local variables here
begin
if :new.olog_num is null then
select q_tai_ologrec.nextval into :new.olog_num from dual;
end if;
endtr_tai_ologrec_serial_i;
------解决方案--------------------
- SQL code
select q_tai_ologrec.nextval into :new.olog_num from dual; --改为下面试下:new.olog_num := q_tai_ologrec.nextval;