existing state of package - Invalidated [message #667196] |
Thu, 14 December 2017 04:11 |
|
saipradyumn
Messages: 419 Registered: October 2011 Location: Hyderabad
|
Senior Member |
|
|
Hi All,
I am executing one package from Linux shell script.This will invoke JAVA application, from that Database procedure will gets executed.
But when I am running continuously the same job, some time following error is coming ,but
some time it executing successfully.
When I am running the same procedure complete from the DATABASE, always its executing successfully.
Unable to find out under which scenarios,existing STATE OF PACKAGE is becoming INVALIDATE
ORA-04061: existing state of package "MAIN.PKG_ABCD_XYZ_HANDOFF" has been invalidated
ORA-04065: not executed, altered or dropped package "MAIN.PKG_ABCD_XYZ_HANDOFF"
ORA-06508: PL/SQL: could not find program unit being called: "MAIN.PKG_ABCD_XYZ_HANDOFF"
Please help me to understand on this .
Thanks
SaiPradyumn
|
|
|
|
|
|
|
|
|
|
|
Re: existing state of package - Invalidated [message #675293 is a reply to message #675291] |
Thu, 21 March 2019 07:59 |
cookiemonster
Messages: 13925 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
It only happens if the package is recompiled directly or if one of it's dependant objects is altered.
It also only happens if the package in question has global variables (A package without globals has no concept of state).
|
|
|
|
|
|
|
Re: existing state of package - Invalidated [message #675329 is a reply to message #675325] |
Fri, 22 March 2019 04:24 |
cookiemonster
Messages: 13925 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
So your doing DB changes that invalidate a package that has a state while the application is connected?
This is going to be hard to avoid.
Why can't you just temporarily shutdown the application?
Do you really need the global variables (this problem will go away if they're removed)?
|
|
|
|
|
Re: existing state of package - Invalidated [message #675378 is a reply to message #675357] |
Mon, 25 March 2019 07:49 |
|
saipradyumn
Messages: 419 Registered: October 2011 Location: Hyderabad
|
Senior Member |
|
|
Hi Michel,
Thanks for your valuable suggestions.We will completely avoid the DB Deployments in production on Week days.
But in UAT, if there is necessity to apply the releases we will shut down all application servers to avoid this kind of issues .
Thanks
SaiPradyumn
|
|
|