哪些情况会导致 Oracle 包失效?
产生这个问题的场景:
我们有一个包是另一个包的依赖项，有时对父"包进行更改会导致依赖包无效，但有时不会.
We have a package that is a dependency of another package, sometimes making changes to the "parent" package causes the dependent package to become invalid, but sometimes it doesn't.
它曾经让我们感到意外.
It has caught us by surprise before.
简单地了解导致失效的原因会非常有用，这样我就可以预测/计划它.
It would be very useful to simply understand what causes invalidation so I could predict/plan for it.
推荐答案
更改包依赖的任何对象(例如表、视图、触发器、其他包)将自动将包标记为无效.正如上面 tuinstoel 所指出的，Oracle 足够聪明，可以在第一次使用包时重新编译它.
Changing anything object that a package relies upon (e.g. tables, views, triggers, other packages) will automatically mark the package as invalid. As tuinstoel notes above, Oracle is smart enough to recompile the package when it is first used.
如果您对此感到担忧，每次进行架构更改(例如表、视图、触发器、过程)时，运行 DBMS_UTILITY.compile_schema(或让您的 DBA 执行).这将强制编译所有包，并在您发现错误之前让您知道哪里有错误，或者是否有错误.
If you are concerned about this, every time you make schema changes (e.g. tables, views, triggers, procedures), run a DBMS_UTILITY.compile_schema (or have your DBA do it). This will force compile all the packages and let you know where, or if, there are errors before you find them the hard way.
相关文章