> "Fink, Dan" wrote: > > 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
Dan, Part of the answer is in the existence of the initialization section of a package. If the initialization section is modified after a session has called the package, it may look uncomfortable for this session. To keep track of everything, I would personally call time() every time I call a procedure I have not yet executed, and check that it has not been modified since then the next times I call it, but this is a pure guess. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
