ORA-04084 是 Oracle 数据库中的一个错误,通常与 PL/SQL 过程中的对象(如函数、过程、包)的重新编译或状态变更有关。以下是对该错误的详细解答: 1. 解释ORA-04084错误的含义 ORA-04084 错误表示在尝试执行或引用某个 PL/SQL 对象(如函数、过程或包)时,该对象的状态与当前会话或数据库的状态不一致。这通常...
假设GetTableMaxid是另外一个用户a的函数 grant execute on a.GetTableMaxid to spes; create synonym spes.GetTableMaxid for a.GetTableMaxid; 重新编译触发器
ORA-04091 table string.string is mutating, trigger/function may not see it Cause: A trigger (or a user defined PL/SQL function that is referenced in this statement) attempted to look at (or modify) a table that was in the middle of being modified by the statement which fired it. Action...