try:create or replace trigger da_delete
before delete on da
for each row
begin
update da set xh=xh-1 where id=:old.id and xh>:old.xh;
end da_delete;
before delete on da
for each row
begin
update da set xh=xh-1 where id=:old.id and xh>:old.xh;
end da_delete;
create or replace trigger da_delete
before delete on da
for each row
begin
update da set xh=xh-1 where id=:old.id and xh>:old.xh;
end da_delete;
错误信息:
ORA-04091:表da 发生了变化,触发器/函数不能读
ORA-06512:在"da_delete",line 2
ORA-04088:触发器'da_dalete'执行过程中出错
create or replace trigger da_delete
before delete on da
for each row
begin
update da set xh=xh-1 where xh>:old.xh;
end da_delete;
还是出错,错误信息一样。
xh是不是主键?
create or replace trigger da_delete
after delete on da
for each row
begin
update da set xh=xh-1 where xh>:old.xh;
end da_delete;
就是在触发器中进行select也不行!这是一个比较烦的问题!