deploying pl/sql-package to a 7x24h producition environment
Hello,
in our Oracle-database (9.2.0) we are using self-written plsql-packages with dependencies to each other (for example: package pkg_a calls function pkg_b.fct_b()...).
If we install a newer version of the packages, the application fails with an error "...package has been discarded...".
As our application has to work 24 hours 7 days a week how can one avoid this error?
I know about compiling the package-body only but what if I have to add new functions/procedures to the specification?
In this case I have to compile whole the specification and the body and the package state will be changed.
Tank you for your answers.
Regards
Marc Bisping