我写了一个删除触发器，可以编译通过
可是在触发器的执行部分里只要有select 语句触发器触发时就报错
我是否只能得要用游标来实现select 的功能呢！！！

select的内容有没有赋予变量？
如果是当前记录，只要用new 或者 old引用就可以了（删除就是old）

What is your error message? Is it mutating error?

Sounds like a mutating table error.  Show us the error trace so we can suggest some work-arounds.

error is ora-04098

$ oerr ora 04098
04098, 00000, "trigger '%s.%s' is invalid and failed re-validation"
// *Cause: A trigger was attempted to be retrieved for execution and was
//         found to be invalid.  This also means that compilation/authorization
//         failed for the trigger.
// *Action: Options are to resolve the compilation/authorization errors,
//         disable the trigger, or drop the trigger.


触发器本身就有问题？
或者是不是所倚赖的对象发身了变化？

重新编译，看看有没有问题

或者帖出你的代码

1。保证你的select的记录只有一条（没用游标的话）
2。保证你要select 的记录进入了一变量

begin
update t_cgjh set jhcgze=(select sum(jhcgje) from
t_cgjhmx where jhid=ld.jhid) where jhid=ld.jhid;
end;

declare
aa number;
begin
select sum(jhcgje) into aa from
t_cgjhmx where jhid=ld.jhid;
update t_cgjh set jhcgze=aa where jhid=ld.jhid;
end;

ora-04091
ora-06512
ora-04088