Suppose there is a package "X" being used by the application (application hosted in WAS)
now for some requirement/urgent production patch the definitions of the PL SQL package(oracle) is changed (addition of one if condition) , now when the package is called form application it gives package was not correct/invalid state (input/output arguments are not changed only functionality), but the package is valid
But if the same package is called again it works, the only issue now is why it failed first time.
Also after executing the package and if the servers are bounced this issue does not occur
can some one help on why such behavior
Thanks in advance
posted 6 years ago
That is the expected behaviour, so that client can understand that the package has been changed. You see "ORA-04068: existing state of packages has been discarded"
message thrown. You don't compile packages in production so often, except deployments.
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads