Okay, I know I'm
being a little lazy on this one, but I'm very interested to hear the
ideas/conjecture/proof. So away we go....
We recently
encountered a bug in Oracle where a long running process attempted to execute a
procedure that was within a package that had been recompiled since the process
had first executed the procedure. This brings up the question as to whether the
kernel requires that each time the process executes the procedure that the
procedure is exactly the same as when the process first executed it. If so, how
does the process keep track of the version of the procedure that it has
previously executed?
Any input/thoughts
are greatly appreciated...
Dan