trigger问题
reate or replace trigger trg_task
after before delete or update on tasktab
for each row
begin
if deleting then --删除工单
dbms_output.put_line('deltering'||:new.taskid);
-- commit;
elsif updating then --更新工单
dbms_output.put_line('updating'||:new.taskid);
insert into histasktab(taskid,taskname,orgtime)values(:new.taskid,:new.taskname,:new.orgtime);
-- commit;
else
raise_application_error(-20001,'You should never ever get this error.');
end if;
这样写什么会有问题!~用before可以,但是取得是以前的老记录,我要取更新之后的记录!~
end tri_task;