ora_04091 触发器不能读???
急,在线等,解决即给分!!!
触发器:
create or replace trigger zsf_py_cj_bj
after insert on py_cj
for each row
declare
stmt varchar2(200);
begin
stmt := 'update py_cj t set bj = (select bh from student t1 where t.xh = t1.xh ) ' ||
'where bj is null';
EXECUTE IMMEDIATE stmt;
end zsf_py_cj_bj;
执行:
insert into py_cj(xh,xm,kh,km,nj,xq,zydm)
values('042688','任倩倩','020000','zsf','04','2','100103')
语句时报错:
ORA-04091:表jwc.py_cj发生了变化,触发器/函数不能读
请高手指点!