Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Procedural Consistency

Re: Procedural Consistency

From: Stephane Faroult <sfaroult_at_oriole.com>
Date: Tue, 24 Sep 2002 13:33:25 -0800
Message-ID: <F001.004D84A5.20020924133325@fatcity.com>


> "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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US