Recompiling invalid packages [message #38853] |
Tue, 21 May 2002 05:50 |
Xenofon Grigoriadis
Messages: 33 Registered: May 2002
|
Member |
|
|
Hi everybody!
I have some problems with wright understanding of Oracle internal handling of dependant objects.
My aim is to find a way to automatically recompile all dependant objects, wenn installing patches of say packages or other objects.
What about the ORA-4068 error? I often get it after having installed new versions of packages, but I could not really reproduce the error. When I tried to use a function which was invalid, then the function seemed to be recompiled and used directly, so that I did not get the 4068 at all.
Another thing is, although the oracle documentation says each session has its own instance of the package, it seemed to me, that recompiling a package in a session affects and helps all across other open sessions as well.
So what is right? Oracle documentation or my results?
Thank you in advance,
Xenofon Grigoriadis
Bonn, Germany
|
|
|
|
|
|