Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Procedural Consistency
> "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: sfaroult_at_oriole.com 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: ListGuru_at_fatcity.com (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).Received on Tue Sep 24 2002 - 16:33:25 CDT
![]() |
![]() |