一种PL/SQL程序包失效的解决方案

摘要

针对pl/sql 程序包在运行中有时会出现"程序包失效"的异常情况，通过深入分析该错误与对象依赖机制、自动重编机制和程序包运行机制的关系，结合3个不同的实验，证实了该错误与程序包中全局变量/常量的独有特性有关，并提供了一种解决方案：对新开发程序包，应尽量避免使用全局变量，使用函数来代替全局常量；对现有程序包，在逐步实施代码改造同时，应密切监控错误的发生、定期检测失效的程序包并自动进行重新编译处理。%The pl/sql package in the operation may appear sometimes “ORA-04068”error. The relationship of the error and object-dependent, automatic recompile and the package operating mechanism was analyzed deeply, and the global variables or constants’ unique characteristics are directly related to the error which was confirmed in three different experiments, then a solution to the error was provided:global variables should not appear and function should be used instead of global constants in new packages; For existing packages, the code should be transformed gradually, and at the same time, the error must be closely monitored, and the package must be recompiled automatically when invalid state is found by failure detection on a regular basis.