What is the error and how is the error occuring? My experience has been:
1. Long running SQL calling PL/SQL function: will die due to invalidated state of the function. 2. Long running PL/SQL calling PL/SQL procedure (statically): cannot re-compile the procedure during the run as it is pinned. 3. Long running PL/SQL calling PL/SQL procedure (dynamically): will just run whatever procedure exists at the time of the call. - Bill. At 12:43 24/09/2002 -0800, you 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan 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).