Thanks, I'll take a look.. -----Original Message----- Sent: Friday, September 27, 2002 12:03 PM To: Multiple recipients of list ORACLE-L
Dan, The default is for oracle to determine this by timestamp. You may want to experiment with the REMOTE_DEPENDENCIES_MODE parameter. This may not apply to your situation as I don't know if it applies to dependencies on a local database as well. e.g. ALTER SESSION SET REMOTE_DEPENDENCIES_MODE = {SIGNATURE | TIMESTAMP} It's in the Oracle 8i Application Developer's Guide. Jared "Fink, Dan" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 09/24/2002 01:43 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Procedural Consistency 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan 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).