Re: Dependencies and invalidations.

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Tue, 25 Apr 2006 04:43:15 GMT
Message-Id: <pan.2006.04.25.04.43.14.724571@sbcglobal.net>

On Mon, 24 Apr 2006 20:00:40 +0200, Frank van Bortel wrote:

> I thought you mixed up stored outlines vs. stored procedures.
> Quite different beasts; mixing those two up would require some
> form of intoxication, knowing your thorough comments and
> level of professionalism.

Actually, I suddenly felt interested (cause by a post on ORACLE-L) in the topic and started investigating. I suddenly realized that I don't understand the subtleties of how a procedure can get invalidated. The answer to my question is that the procedure is implicitly parsed when the underlying SQL suddenly changes the execution path, but as long as this re-parse is successful, the unit is not invalidated.

-- 
http://www.mgogala.com

Received on Mon Apr 24 2006 - 23:43:15 CDT