Re: Are packages evil?

If you have any type of proper maintenance procedures then the only package compile errors that you 'should' ever see in production are the result of either 1- failing to move a new referenced object or object modification to production prior to re-compiling the package or 2- you failed to issue a necessary grant prior to the package upgrade. Both of these problems are procedural errors that can usually be fixed in a few seconds. Neither error should actually happen, but developers are prone to forget to move related objects.

More importantly proper change management procedure would require that you have the original source available for immediate recompilation if an error that was not immediately fixable occurred or a bug was found in the code after it was placed in use.

Frank, hit the nail on the head. You need to separate test from production.
-- Mark D Powell -- Received on Thu Jan 20 2005 - 13:53:40 CST