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

Home -> Community -> Usenet -> c.d.o.server -> Re: Dependencies and invalidations.

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

Original text of this message

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