oracle 触发器 不知道什么错误 无法运行
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;